mail merge from excel

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

When I do a mail merge from excel spread sheet
(addresses), the zip comes out like 99887.0, it always has
the .0 on the end. I have tried to format cell under
special doesn't work. any help would be appreciated.
thanks
 
I've saved a couple responses from Deb Dalgleish.

She's recommended this to other people with formatting problems between excel
and word.

==============

In Word, after you have inserted the Merge fields, press Alt+F9, to view
the field codes.

In the field code for the Zip Code, you can add a switch to format the
number. For example:
{ MERGEFIELD "Zip" \# "00000" }

Press Alt+F9 again to hide the field codes, then view the merged data.
 
Back
Top