How do we get Mail Merge to recognize a leading 0 (zero) in the Z.

C

CM IT Terry

Our ZIP codes here in the Northeast start with a 0 (zero). I have the column
formatted as a ZIP code in Excel 2003, but it keeps coming over to Word 2003
as a 4 digit number, cutting off the leading zero. Help!
 
D

Doug Robbins

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Dropping Leading Zeroes 3
ZIP code problem 2
Leading zero from Zip Code not print on Label Merge 6
how do i display leading zeros when mail merge to Word doc 1
Format Zip Codes in Excel for a Mailmerge 2
Mail merge prints zip as 0 instead of correct code 3
How do I not drop the leading 0 in a zip code mail merge? 2
Function to Count Zip Code Digits With Leading Zero 2

Top