Home |
Search |
Today's Posts |
#1
|
|||
|
|||
retaining the font used in each row of Excel in a mail merge
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 |
#2
|
|||
|
|||
Hi ?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 :-) |
#3
|
|||
|
|||
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-" wrote: Hi ?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 :-) |
#4
|
|||
|
|||
Hi ?B?c3NhdHRlcndoaXRl?=,
Thank you so much! Your suggestion did work perfectly. You're welcome :-) Glad it all functioned for you. -Cindy Meister |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where is the Helvetica font? | Microsoft Word Help | |||
Retaining special Excel formatting when merging | Microsoft Word Help | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Default font - possible bulletproof fix in Word 2003 | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout |