Retaining source formatting from Excel with a mail merge in Word

[Guest]

Recently at my work we changed from Office 2000 to 2003 and now when I do a
mail merge with a source document from Excel it doesn't keep the Excel
formatting in the Word document. The main problem is with Currency
formatting. I change the currency format in Excel, but when I complete the
mail merge in Word I lose it. I know there must be an easy fix, but I
haven't been able to find it.

 

[Suzanne S. Barnhill]

There are two ways to deal with this problem:

1. You can change the way Word links to Excel (revert to DDE instead of the
new default OLEDB).

2. You can add a numeric picture switch to the mergefield.

See http://homepage.swissonline.ch/cindymeister/MM2002/MM2002.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Graham Mayor]

Word 2003 (annoyingly) changed the way that Word connects to its data files
for mail merge. Word now receives only the raw data and is now expected to
provide the formatting - see
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>