Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zip code formatting
I used this site and found some great information.
http://www.gmayor.com/formatting_word_fields.htm My Excel file contains zip codes that are 00000 and 00000-0000. One of the suggestions in the above site allows me to make all my 00000 zip codes add actual 0000's to the code so it appears as 12345-0000. I can live with that, assuming the post office can. I would prefer if Word could distinguish my 5 digit zips from my 9 digit zips and output just what was in Excel. However, if it can not, I'll live. However, when I use the IF statement as shown in the above site, and then tell Word to Update all Labels in the merge, I get a "," and "-0000" (w/o the quote marks) in every label on the sheet. i.e. if there are ten blank labels on the sheet, and I am only merging four names and addresses, the "," and "-0000" populate the remaining six labels. The only place that has a "," and the "-0000" is the comma between city and state fields and the "-0000" comes from the If statement that has no zip code. I've checked the characters in the merge fields and all seems to be fine. What have I done wrong?? Your guidance is appreciated. Oh yeah, I am using Word 2003 and Windows 2000. kojak |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Word to retain Excel formatting, eg zip code, ssn? | Mailmerge | |||
Why is there not a formatting code for a font change? | Microsoft Word Help | |||
zip code formatting merge | Mailmerge | |||
Formatting zip code in mail merge from Excel to Word | Microsoft Word Help | |||
Apply Style but keep direct formatting? | New Users |