| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Mail Merge some international postal codes displayed as "0"
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 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mail merge with attachments | Mailmerge | |||
| Mail merge drops zip codes and replaces with zero | Mailmerge | |||
| How do I get mail merge to print full zip codes | Mailmerge | |||
| How do I get mail merge to print full zip codes | Mailmerge | |||
| International characters in mail merge | Mailmerge | |||
Linear Mode
