Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jz0129 jz0129 is offline
external usenet poster
 
Posts: 2
Default how to fomat zip codes in Mail Merge

I am doing an Excel mail merge and I formatted the zip codes in excel to have
a 0 in front of them. But when I go into Word, it takes away the 0 at the
beginning of the zip code. What do I do?

  #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 how to fomat zip codes in Mail Merge

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

"jz0129" wrote in message
...
I am doing an Excel mail merge and I formatted the zip codes in excel to
have
a 0 in front of them. But when I go into Word, it takes away the 0 at the
beginning of the zip code. What do I do?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jz0129 jz0129 is offline
external usenet poster
 
Posts: 2
Default how to fomat zip codes in Mail Merge

OMG, thank you so much !!!!!!! It worked... a little confusing at first but
its OK now

"Doug Robbins - Word MVP" wrote:

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

"jz0129" wrote in message
...
I am doing an Excel mail merge and I formatted the zip codes in excel to
have
a 0 in front of them. But when I go into Word, it takes away the 0 at the
beginning of the zip code. What do I do?




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
International Zip Codes & Mail Merge Roy Mailmerge 1 July 25th 06 09:19 PM
Zip codes starting with 0 in Mail Merge chris76 Mailmerge 1 May 18th 06 06:41 PM
mail merge problem with Zip codes Steve Mailmerge 4 January 2nd 06 05:34 PM
How do I fomat and envelope using mail merge? Dennis Cheever Mailmerge 4 August 6th 05 03:45 PM
how to use postal codes on a mail merge Scott972 Mailmerge 1 July 19th 05 04:00 AM


All times are GMT +1. The time now is 03:50 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"