Word mail merge zip code problem

We will try to get that published soon. Cindy, I just posted instructions on another way to get the leading zeroes to appear, if you cannot resolve the connection problem. When I attempted to change to DDE, it reordered the contents ofthe address box to add my fist column into my address my first column is a category, not he first name Any way to fix this?

I found this way is the only thing that worked for me. The site link below explains, but this is the ginst of it:. The latter of the two. Next, use your. I am sitting here working on merging addresses from my Excel file to Word and these zeroes show up in the zip code and I almost lost it until I remembered Google.

I stumble on your article. I followed the steps and it worked like a charm. When I type them in the field they just disappear? How to fix that issue!! ThNk you!! I am using the new version of Excel. I converted the file to. This is amazing. Skip to primary content. Skip to secondary content. Word will display the field code. Pingback: Mail Merge Problem: Leading Zeroes Missing from Zip Codes Notes from the Help Desk Would yu please be more specific as to which word document one clicks into the filed code in, and how do you click into a field code?

Here are the steps: 1. Thanks so much! This issue has been driving me crazy. Your explanation worked perfectly. The trick worked for me, i was able to insert the required zero in the field.

Thanks a lot. Thanks Dave. Saved me many hours. Alternate solution worked on for me. An example of this is a personalized newsletter in which the body of the newsletter is the same for all recipients, but the mailing address and introduction are different. The most common issue with creating the merged publication is not saving both the publication with the merge fields and the merged pages publication.

Create merged publication is step three in the Mail Merge wizard. In this step, you have three choices:. Print This option prints the merged publication. Merge to a new publication This option opens a new publication with a page for each set of merge data. Add to an existing publication This option prompts you to choose a publication, and then it adds, the merged pages to the end of that publication.

To save both the merged publication and the publication that contains the merged fields, click the Merge to a new publication option. A new publication window opens and displays the merged pages publication. The merge field publication is hidden behind the merged pages publication. Be sure to save both publications. The most common issue with printing the publication is printing one of each of the merged pages on a sheet of paper—for example, one of each different mailing labels on a sheet of mailing label paper.

This happens because if you choose the Print option, the Print dialog box defaults to the Multiple copies per sheet option and prints out an entire sheet of labels for each address rather than printing one address per label on the sheet.

To print different sets of merge data — for example, different names and addresses — on each sheet of paper, click Multiple pages per sheet in the Printing options section. To make this rule work, use default templates from MS Word. Or, you can use GMass for better personalization. When creating a mail merge on a Mac, you must use Outlook as the default email program if you want to send out mail merges.

Otherwise, there will be issues in using the Merge to Email function. You can change your default email program in Mail. You can also use GMass to send out a mail merge via Gmail more easily.

Under settings, change the default app from Outlook to an alternative of your choice. Alternatively, you can use GMass for a quick mail merge setup that works straight from Gmail. In addition to eliminating MS Word limitations discussed above, GMass offers a range of advanced mail merge features not available with standard MS word mail merges:. As word processors like MS Word have many limitations, GMass offers advanced features for making mail merge easier and more effective.

If you want to see how these mail merge features can help your business, install the GMass Chrome extension today. Your email address will not be published.

Save my name, email, and website in this browser for the next time I comment. Common Word mail merge problems and how to fix them 1. Limitations: The font, color, and size change during the mail merge process. Mismatch of personalization tags In the event that your personalization tags are mismatched and you have hundreds of recipients, you could end up sending something like this: Solution GMass Chrome extension lets you work directly from the Gmail interface to eliminate tag mismatch issues.

Unwanted line spaces There is a known problem with Microsoft Word that leads to uneven line spacing and unintended paragraph breaks when performing the mail merges.