Zip code with O as first digit

  • Thread starter Thread starter CS
  • Start date Start date
C

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
 
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
 
Back
Top