Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2019, 06:04 PM
JennEx JennEx is offline Text Values in Data Source Merging as "0" Windows XP Text Values in Data Source Merging as "0" Office 2013
Competent Performer
Text Values in Data Source Merging as "0"
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default Text Values in Data Source Merging as "0"

I have this field in my mail merge document:




{MERGEFIELD "UNIT"}


It merges data from the data source (Excel Worksheet) from a column headed UNIT.


The UNIT column contains predominently numbers, but there are a few text values as well, "LOWER", "UPPER", "AF-1" for example.


When the merge is completed (and in preview as well), the new document shows those records with a value of "0" instead of the textual value in the cell of the database (ie LOWER, AF-1 etc).


The records that aren't textual, ie values in the UNIT column equal to 1, 2, 3, 4 5 etc all display in the merged document fine. It just seems to be the text values.


Any idea what might be causing this behaviour?
Reply With Quote
  #2  
Old 05-28-2019, 09:55 PM
macropod's Avatar
macropod macropod is offline Text Values in Data Source Merging as "0" Windows 7 64bit Text Values in Data Source Merging as "0" Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Read Mailmerge Data Format Problems in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-29-2019, 04:29 PM
JennEx JennEx is offline Text Values in Data Source Merging as "0" Windows XP Text Values in Data Source Merging as "0" Office 2013
Competent Performer
Text Values in Data Source Merging as "0"
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

Thank you Paul.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Values in Data Source Merging as "0" "word was unable to open the data source" error meganadand Mail Merge 6 02-27-2020 11:25 AM
Catalog Merge in Publisher error: "This data source contains no visible tables" highroadnm Publisher 0 01-20-2018 02:35 PM
Combine "sort within groups" and "identify duplicate/unique values" in two different variables. civilcervant Excel 3 06-12-2017 07:27 AM
Text Values in Data Source Merging as "0" The "body of text" for all odd-numbered pages are all "vertically-centered-aligned". keepcalmandreadabook Word 5 03-27-2017 04:08 PM
Text Values in Data Source Merging as "0" Applying "Paper Source" settings to multiple sections in a mail merge does not apply ChrisC Mail Merge 1 06-18-2012 07:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft