View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
n n is offline
external usenet poster
 
Posts: 5
Default Merge Randomly Drops Zip Code

I am creating a merge for address labels in Word 2003, pulling from an Excel
2003 file. All rows in Excel are formatted the same with the zip code as
general and includes either 5 or 9 numbered codes. When I select my file
from Word and it opens the Mail Merge Recipients dialog box some fields show
a 0 instead of the zip code data. I've double checked the formatting and
changed it to number from general but it continues to occur. If I continue
with the merge those 0 fields transfer to the labels (City, ST, 0) and I am
left with random multiple addresses that are incomplete.

The list is 478 rows so going row by row to fix it for each dropped field
per label is very tedious and time consuming.

Any suggestions as to what I'm doing wrong? Thanks in advance.