mail merge from excel

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
 
D

Dave Peterson

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