View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Make 1st 0 show in Word mail merge from Excel data source?

See the zip code section of "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, originally posted via msnews.microsoft.com

"Janine" wrote in message
...
Although I've got zip codes in Excel 2007 database showing properly, when
I
do a mail merge in Word 2007, the first 0 in the zip codes have
disappeared.
I have formated the zip code column in Excel as text and the 0 s appear
there.
Thanks so much for your help!