Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2005

Tip: Looking for answers? Try searching our database.

Merge Field Formatting - Retaining the Font Info

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kpchop - 25 Aug 2005 14:05 GMT
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 - 25 Aug 2005 19:01 GMT
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.

Signature

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

> Version: Word XP
>
[quoted text clipped - 19 lines]
>
> Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.