Mail merge using Excel data

[ladyt]

Using P2003 and mail merge

In Pub, whenever my "zipcode" field (that I am getting from an Excel
file) has zip +4 digits, "0" shows up in the Pub merge results. In the
Excel file, I have tried having the column attributes set as Custom,
Text, and others to see if that was causing the problem, but still the
same results.

How can I get the zip + 4 to display correctly in the Pub merge? Thanks
much for your help.

 

[Rae Drysdale]

Try inserting an apostrophe before the figures in Excel. This tells Excel
that the cell contains text. Does this work for you?

 

[Mary Sauer]

Save the Excel file as a .csv. See if that works.

 

[ladyt]

Thank you for your replies. However, I tried both methods, and neither
one worked. I was running out of time, so I manually put in the addresses.