Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My merge document drops every 9th recipient | Mailmerge | |||
when I use mail merge the merge drops the '0" of zip code | Mailmerge | |||
My zip code field on the mail merge drops leading zeroes, why? | Mailmerge | |||
When I mail mrge from Excel into Word, it drops 1st 0 in zip code | Mailmerge | |||
Mail merge drops leading zero from zip code 07001 comes out 7001 | Mailmerge |