word ignoring formatting in spreadsheet when I do mail merge

[Susan Bompadre]

Please help: Word taking the commas out of fields that contain numbers when
using mail merge into form letters. Data file is in Excel, and the
spreadsheet is formatted correctly.

 

[Doug Robbins - Word MVP on news.microsoft.com]

Excel stores formatting separate to data and mailmerge in Word only accesses
the data. To reinstate the formatting in a merge document, you must add
formatting switches to the merge fields.

To see how to do that, take a look at the item "Formatting Word fields with
switches" on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com