Losing zipcode when I merge!

A

Anne

Hi-
Can anyone help!?!?!

When I merge my excel file to Word the 5 digit zip 02601 (the format in
Excel) loses the first number and become 2601.
I hve made sure that the cell format is correct in Excel (5 digit zip) but
it still drops that first zero.

Does anyone know what I should do?

Thanks!
 
P

Peter Jamieson

Use Alt-F9 to show the "underlying field codes" in Word, and wehre you have

{ MERGEFIELD "zipcode field" }

change it to

{ MERGEFIELD "zipcode field" \#00000 }

(If you have

{ MERGEFIELD "zipcode field" \*Mergeformat }

change it to

{ MERGEFIELD "zipcode field" \#00000 \*Mergeformat }

Peter Jamieson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Page numbering with Merged Document and IF statements 1
Format Zip Codes in Excel for a Mailmerge 2
Mail Merge Dropping Leading Zeroes 3
Why do zip codes w/ leading zeros disappear when doing mail merge 1
Postal Codes in Word/Excel merge 1
Mail merge prints zip as 0 instead of correct code 3
Mail merge envelopes 1

Top