Mail Merge some international postal codes displayed as "0"

C

cmcintyre

By default zip codes that include letters in them show up as a "0", This is
resolved by going to Tools-Options-General and checking the box "Confirm
conversion at open". When importing the data from the spread sheet do not
keep the default conversion option displayed as "OLE DB Database Files", I
have confirmed that the second option will work "Microsoft Excel Worksheet
via Converter" will work. From there you can work through the mail merge
without any dificulty and the zip codes from Canada and England will not show
up as "0" as they did before. If you keep the "OLE DB Database Files" option
selected you will not be able to import the zip codes without experienceing
the problems mentioned
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Postal Codes in Word/Excel merge 1
Mail merge prints zip as 0 instead of correct code 3
Some mail merge fields not pulling into document 2
How do I not drop the leading 0 in a zip code mail merge? 2
Mail Merge and Zip+4 1
International Zip Codes & Mail Merge 1
preceeding zeros in postal codes of mail merge 2
Postal code shows "0" when non-numeric characters present 6

Top