Thread: Conditional Fields Breaking Down With Large Merge
View Single Post
 
Old 01-30-2013, 03:32 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,384
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
Hi Gabe,

The issue appears to be that your 'Reason' column has mixed data types - numbers and text.

When Word performs a mailmerge, it analyses the datasource to try to determine what kind of data each field contains. It does this by looking at (IIRC) the first 16 records. If they're mostly numeric, Word may treat the entire field as numeric, in which case any text records get treated as if they are 0s. You can work around this by either:
• inserting a number of dummy text-only records at the top of the worksheet;
• sorting the worksheet so that the text-only records appear at the top; or
• inserting another column into the worksheet that uses formula to turn either the numbers in the affected column into text (eg =IF(ISNUMBER([@Reason]),"NA",[@Reason])) or the affected words into numbers (eg =IF([@Reason]="Too New",9999,IF([@Reason]="TRC",8888,[@Reason])), then using that column and its values for the condition evaluations in the mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote