See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"aedcone" wrote in message
...
I have created a data source in Excel 2007 with addresses. When I mail
merge
to create address labels in Word 2007, my ZipCodes are NOT appearing
correctly. The zip codes all begin with "O" and when I merge it's
dropping
the "O." In Excel I have formated the column as ZipCode (not the the 9
digit
zipcode). In Excel I see the "0," BUT when I look up in the forumla bar
the
"0" doesn't appear.
Any suggestions how to solve this would be greatly appreciated.