Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
word ignoring formatting in spreadsheet when I do mail merge
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
word ignoring formatting in spreadsheet when I do mail merge
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 "Susan Bompadre" Susan wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge in Word using Excel Spreadsheet | Microsoft Word Help | |||
Attaching different spreadsheet in Mail merge | Mailmerge | |||
How to? Embedded Word (e-mail merge) Doc with tie to table in main Spreadsheet (.XLS) | Mailmerge | |||
How can I convert an excel spreadsheet to mail merge in word? | Microsoft Word Help | |||
Word 2003 Mail Merge from Excel spreadsheet database | Mailmerge |