how to fomat zip codes in Mail Merge jz0129 5/30/2007 3:19:02 PM 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?

Re: how to fomat zip codes in Mail Merge "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/30/2007 3:37:03 PM 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" <jz0129[ at ]discussions.microsoft.com> wrote in message news:34E1518A-F4D8-4E0F-B169-2BA25E06F52C[ at ]microsoft.com... [Quoted Text] >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? >

Re: how to fomat zip codes in Mail Merge jz0129 5/30/2007 3:55:00 PM OMG, thank you so much !!!!!!! It worked... a little confusing at first but its OK now "Doug Robbins - Word MVP" wrote: [Quoted Text] > 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" <jz0129[ at ]discussions.microsoft.com> wrote in message > news:34E1518A-F4D8-4E0F-B169-2BA25E06F52C[ at ]microsoft.com... > >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? > > > > >