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 / June 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ssatterwhite - 08 Jun 2005 07:05 GMT
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- - 08 Jun 2005 13:23 GMT
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
[quoted text clipped - 7 lines]
> 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 - 09 Jun 2005 05:51 GMT
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!

> Hi =?Utf-8?B?c3NhdHRlcndoaXRl?=,
>
[quoted text clipped - 26 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)
Cindy M  -WordMVP- - 09 Jun 2005 12:58 GMT
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
 
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.