K
kojaks43
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
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