retaining the font used in each row of Excel in a mail merge

[ssatterwhite]

Using Excel 2002 and Word 2002
I want to produce a list of various fonts from which customers can choose
for their invitations. I like to change the choices of fonts on a regular
basis. The easiest way to do this is to create an Excel table where each row
of fields is in a different font. Field 1 is the name of the font, field 2
is the alphabet in all caps, field 3 is the alphabet in lower case, and
numbers 0-9 are in field 4. I would like to do a mailmerge in Word using the
Directory option, resulting in a list, showing how each font looks. But the
resulting merged document changes all the fonts into Word's default font.
Is there anyway to preserve the different fonts in the Excel table in the
merged document?--
sharon

 

[Cindy M -WordMVP-]

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

Using Excel 2002 and Word 2002
I want to produce a list of various fonts from which customers can choose
for their invitations. I like to change the choices of fonts on a regular
basis. The easiest way to do this is to create an Excel table where each row
of fields is in a different font. Field 1 is the name of the font, field 2
is the alphabet in all caps, field 3 is the alphabet in lower case, and
numbers 0-9 are in field 4. I would like to do a mailmerge in Word using the
Directory option, resulting in a list, showing how each font looks. But the
resulting merged document changes all the fonts into Word's default font.
Is there anyway to preserve the different fonts in the Excel table in the
merged document?

No, there is not.

The only chance you MIGHT have of achieving this is to copy/paste the Excel
table into Word, then use that as the Merge data source. Mail merge can only
pick up font formatting from a Word table, and then only using a special trick.
You need to remove the term MERGEFIELD from mergefields in the main merge
documetn. But note that you must retain the term in at least one of the merge
fields, otherwise Word won't execute the merge.

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

 

[ssatterwhite]

cindy,
Thank you so much! Your suggestion did work perfectly. I had to make a few
adjustments in spacing and also I had to add a dummy field in order to have
one Mergefield element, so the merge would take place. Thanks a million!

 

[Cindy M -WordMVP-]

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

Thank you so much! Your suggestion did work perfectly.

You're welcome Glad it all functioned for you.

-Cindy Meister