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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mail merging in Excel 1
Leading 0 in Mail Merge document 4
Excel Help 2
Sharing workbooks limitations - Merged Cells 12
why cant I merge cells in a reguler spread sheet 1
How do I do a "mail merge" from excel to excel? 1
Mail Merge Formating Issues 3
some text shows in merged cells but not all 2

Back
Top