Re:Try again. Don't use the QUOTE mark.
Thanks, Bob! Here goes:
I have a mailing list in Excel. I have formatted one column of cells so that it is recognized as a zip code.
On the Excel sheet all the zeros are there. When I print out the mailing list directly from Excel the zeros are all there.
Something happens between Excel and mail merge in Word. When I go through the process of creating labels, I open the Excel document, click OK and it is displayed in another format without the zero in the zip code.
So then when I go to print labels, the zip codes are missing the first zero (as in 06457) throughout.
Any ideas, anyone? Never experienced this with Office 2000 BTW.
Was this reply helpful? (0) (0)