Originally Posted by macropod

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.