Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
My merge document drops every 9th recipient T Morgan Mailmerge 1 November 5th 09 01:28 AM
when I use mail merge the merge drops the '0" of zip code Michbostn Mailmerge 1 June 16th 07 11:10 PM
My zip code field on the mail merge drops leading zeroes, why? PETEinBOSTON Mailmerge 1 March 2nd 07 04:01 PM
When I mail mrge from Excel into Word, it drops 1st 0 in zip code AllenVV Mailmerge 2 December 4th 05 06:45 AM
Mail merge drops leading zero from zip code 07001 comes out 7001 Carl Mailmerge 4 August 19th 05 06:20 PM


All times are GMT +1. The time now is 03:47 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"