Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
losing zeros on zip codes when I create mail merge
When I merge excel list to Word I lose the first zero of zip code - comes in
as 8401 instead of 08401. How do I correct? Thank you. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
losing zeros on zip codes when I create mail merge
Is the ZIP code set up as a string variable in Excel?
MsShagas wrote: When I merge excel list to Word I lose the first zero of zip code - comes in as 8401 instead of 08401. How do I correct? Thank you. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
losing zeros on zip codes when I create 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 "MsShagas" wrote in message ... When I merge excel list to Word I lose the first zero of zip code - comes in as 8401 instead of 08401. How do I correct? Thank you. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
losing zeros on zip codes when I create mail merge
Thank you for your quick reply. Could you please elaborate on set up of "string
variable" - I did format the cells to Special - Zip Code. "Fred from NYC" wrote: Is the ZIP code set up as a string variable in Excel? MsShagas wrote: When I merge excel list to Word I lose the first zero of zip code - comes in as 8401 instead of 08401. How do I correct? Thank you. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
losing zeros on zip codes when I create mail merge
Thank you for your help.
"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 "MsShagas" wrote in message ... When I merge excel list to Word I lose the first zero of zip code - comes in as 8401 instead of 08401. How do I correct? Thank you. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
preceeding zeros in postal codes of mail merge | Mailmerge | |||
How do I get mail merge to print full zip codes | Mailmerge | |||
Losing Mail Merge Items after I perform "Merge Option". | New Users | |||
Losing Mail Merge Items after I perform "Merge Option". | New Users | |||
how do i create a mail merge for email using excel as a data sourc | Mailmerge |