Zip code with O as first digit

[CS]

Help!
I'm trying to do an address label mail merge with Word
and Excel as the data source. I have zip codes that begin
with the number 0. I've formatted the cells in Excel
for "Zip Code", the correct format displays in the
spreadsheet but not in the merged document, the 0 is
missing.
Any thoughts, Thanks

 

[Debra Dalgleish]

After you select your Excel file as a data source, you should see a
'Confirm Data Source' dialog box. From that list, choose 'MS Excel
Worksheets via DDE (*.xls)', and your formatting will be retained.

If you connect through a different source, you can format the fields in
the Word document. For example, to specify a number of decimals:

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

 

[David McRitchie]

or for those less oriented to MS Word you could format the
cells as text in Excel in the proper format beforehand.
with a macro see
http://www.mvps.org/dmcritchie/excel/join.htm#fixuszip5
then you will be using text and can handle zip, zip+5,
Canadian and other zip codes.