Merge Field Formatting - Retaining the Font Info

[kpchop]

Version: Word XP

Situation: When we merge from an Excel file into Word, the onscreen
appearance in the main doc is fine, but the actual merge prints out the font
formatting that was in the Excel doc (arial) instead of the merge field
formatting (times new roman). So everywhere we have info coming in from
Excel, it shows up formatted Arial, 12 instead of Times New Roman, 12. There
are no styles involved. When you right-click the field and choose formatting
that way, it show as Times New Roman, and again, when you preview the merge,
it's fine onscreen.

I've read the articles posted in this forum and gone to the sites about
merge field formatting, but they focus on currency, zip codes, etc. I get the
idea that there may be a switch to control this and will start searching for
those, but if anyone has a quick fix for this, that would be fantastic!

Thanks!

 

[Doug Robbins]

Replace the Mergeformat in the merge fields in the main document with
Charformat and then apply the desired formatting to the M of Mergefield in
the fields.

--
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