Mail merge

[al cal]

When using an excel 2002 ss in a mail merge,for example,
20.50 will print in the letter as 20.5 and I cannot make
it print as displayed in the ss. HELP!

 

[JE McGimpsey]

The "proper" (i.e., best) way to do this is to set the format picture
switch in the Mergefield. See

http://homepage.swissonline.ch/cindymeister/mergfaq.htm#NumFormat

For more on mailmerges, see

http://word.mvps.org/FAQs/Mailmerge.htm

 

[Gord Dibben]

Al

See this posting by Debra Dalgleish which explains how to retain Excel
formatting when mailmerging to Word.

http://snipurl.com/8t0v

Gord Dibben Excel MVP