Mail Merge Labels (Word 2007) w/ Excel (2007)

[aedcone]

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.

 

[Doug Robbins - Word MVP]

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

 

[BFairall2008]

Make sure that the format in excel is in number format.