Mail Merge/Zip Code

[Bob]

Hello,

I'm using Office XP Pro SP2 with W2K Pro SP4.
When performing a mail merge in Word with an Excel sheet
as the recipient list the ones with a zero as the first
digit of the zip code prints out as a "0" or the "0" is
missing from the zip code.

For example, a zip code of 01122 will print out as 0 or
1122.

The cell for the zip code in Excel is formatted as:

Category - Special
Type - zip code

Please assist.

Thank you.

 

[Debra Dalgleish]

In the Word mail merge, after you select your Excel file as a data
source, you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and your
formatting will be retained.

If you have to connect through a different source, you can format the
fields in the Word document. For example, to format a five-digit zip code:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the zip code. It will look something like:
{ MERGEFIELD "Zip" }
3. Add a switch, to format the number. For example:
{ MERGEFIELD "Zip" \# "00000" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document