Merge Field Not Displaying Same Data as In Source

[MaxArk]

I have a merge field is a document that is not merging the same data
accurately from the source.

I have inserted the merge field in the document exactly as titled from
the Excel data source. Although the data says "Upper" (in the Excel
Source field column), "0" gets merged. It should be "Upper".

Can anyone advise where I should be looking to find why the information
is merging improperly?

Jenn

 

[Doug Robbins - Word MVP]

In Word, from the Tools menu, select Options and then go to the General tab
and place a check mark against the "Confirm conversions at open" item. Then
when you attach the data source to the mail merge main document, select the
DDE method of attachment.

What is probably happening is that with the default ODBC connection, the
system determines from the first 6 or 8 records what type of data is in each
field and it may thus be determining that the data in that field is numeric
rather than there possibly also being text entries.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP