#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Thank you Paul.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"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 |
The "body of text" for all odd-numbered pages are all "vertically-centered-aligned". | keepcalmandreadabook | Word | 5 | 03-27-2017 04:08 PM |
Applying "Paper Source" settings to multiple sections in a mail merge does not apply | ChrisC | Mail Merge | 1 | 06-18-2012 07:11 PM |