Word mail merge with Excel data
 

In addresses the first 0 in the zip code does not show or print when merged
to Word labels.

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx


Bailey wrote:
In addresses the first 0 in the zip code does not show or print when merged
to Word labels.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Here are a couple of options.

1. Format all your zip codes in Excel as text.

2. In Word, before you start the merge:
Tools | Options | General and Check the Confirm Conversion at Open
Then, when you choose the Data Source for the Merge, a dialog should pop up.
Choose worksheets via DDE.

tj

"Bailey" wrote:

In addresses the first 0 in the zip code does not show or print when merged
to Word labels.