Mail Merge to Word Using Formatted Text in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kersterlm - 11 Nov 2004 20:46 GMT

I set up an Address Directory in Excel, fine-tuned my data, then BOLDED
selected contacts.

How do I retain the BOLD formatting when I merge to Word? Again, the
formatting issues I am dealing with are in the FONT only.

Thank you in advance

Reply to this Message

Doug Robbins - 12 Nov 2004 00:11 GMT

Using a \*charformat switch with the mergefields in the mailmerge main
document, you can apply formatting to individual fields, but there is no way
that you can do it with individual records in individual fields.

If there was some criteria for determining which contacts you want to apply
the bold font to, you could probably use a If...then...Else field in
conjunction with the \* charformat switch to achieve what you want.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I set up an Address Directory in Excel, fine-tuned my data, then BOLDED
> selected contacts.
[quoted text clipped - 3 lines]
>
> Thank you in advance

Reply to this Message

Cindy M -WordMVP- - 12 Nov 2004 12:15 GMT

Hi =?Utf-8?B?a2Vyc3Rlcmxt?=,

There's no way to retain font formatting in the data coming across from an
Excel file (or any other non-Word data source).

If the merge require 63 fields or less, then you can copy/paste the Excel
table into Word and link the merge to that. Word can pick up FONT
formatting from data coming across from a Word table. After you insert the
merge fields, Press Alt+F9 to view the field codes. Remove the term
MergeField from the merge fields that should bring across the formatting.
Note that you have to have at least one field in the document that
contains the term Mergefield.

> I set up an Address Directory in Excel, fine-tuned my data, then BOLDED
> selected contacts.
>
> How do I retain the BOLD formatting when I merge to Word? Again, the
> formatting issues I am dealing with are in the FONT only.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message