#Label mail merge from excel update

If you do not see the leading zeroes, click into the field and press F9 to update the field. Click the Mailings tab in the Ribbon and then click Start Mail Merge in the Start Mail Merge group.

Click back into the field and press SHIFT + F9 to hide the field code and display the text.

(The default number format uses # signs, which to Excel means, “Don’t put a number in this position if the number is blank or zero.”)

Click into the field and change it to the following:įormat explanation: I picked five zeroes for the zip code format because a zero in a number format forces Excel to put a number in that position, even if the number is blank or zero.

The problem is, when I print the addresses they duplicate each other on multiple pages in a random pattern Example1: Page one printed John Doe Jane Doe Bill Evans Jane Evans John Dill Jane Dill Bill Smith. It will look like this (with Zip_Code being the name of the field): HELP I have an excel data base of addresses to merge to word to create mailing labels. Click MS Excel Worksheets via DDE (.xls), and then click OK. Select your Excel document from the file picker. In the Confirm Data Source dialog box, click to select the Show all check box. Click ‘ Select Recipients ’ from the drop-down list to define our data source.

In the Word document, click into the field with the zip code, and press SHIFT + F9. Step 1: Start your mail merge from the ribbon button by clicking ‘ start mail merge ’ and selecting ‘ Email Messages ’ from the pull-down list.

Another option is to edit the field codes in Word to make sure all the leading zeroes appear. However, for a variety of reasons (such as a filtered spreadsheet or a conflict with a printer driver), this doesn’t always work.

(See Mail Merge Problem: Leading Zeroes Missing from Zip Codes for instructions.) The best solution to this problem is to change an option in Word that sets up a DDE connection with Excel, and displays the zip code the way it is formatted in Excel, with all leading zeroes.