If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 =?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 :-) |
#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 =?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 :-) |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Font and size are in Excel has gone shaded. Will not let me type. | Hawaiian | Worksheet Functions | 1 | April 21st, 2005 05:42 PM |
I cannot type in my Excel program. The Font and size area is shad. | ohana | Worksheet Functions | 1 | April 21st, 2005 04:48 PM |
Excel font formats | Angie Kay | General Discussion | 3 | February 4th, 2005 03:40 AM |
How do I change the default font color in Excel | Leslie | General Discussion | 1 | October 20th, 2004 02:34 PM |
Bar Charts created in Excel 2003 - font resizes when file is reopened | Lucie Harris | Charts and Charting | 0 | June 16th, 2004 05:56 AM |