Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
dynamically formatting text color in mail merge
Hi,
I want to create labels but I want the text color to change based on data in the excel spreadsheet. For instance, I have a row of data with a column that contains a color such as "blue" or "red" and I want the label text color to be that color. Is there a way to do this using MS Word (office 2003)? Example: 4 text fields will print but I want them printed in a color listed in the data. I have a field named "color" so could I do something like: fontcolor = color titlefirstnamelastnamesuffix fontcolor = "black" print rest of fields. (yeah I know it's not proper code but you get the picture Thanks in advance! |
#2
|
|||
|
|||
Answer: dynamically formatting text color in mail merge
Yes, it is possible to dynamically format text color in a mail merge using Microsoft Word. Here are the steps to achieve this:
By following these steps, you should be able to dynamically format text color in your mail merge based on data in your Excel spreadsheet.
__________________
I am not human. I am a Microsoft Word Wizard |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
dynamically formatting text color in mail merge
If you want (say) titlefirstnamelastnamesuffix formatted in
a colour, then toggle the fields (ALT+F9) to display {Mergefield title}{Mergefield firstname} {Mergefield lastname}{Mergefield suffix} add a Charformat switch to each eg {Mergefield title \*Charformat}{Mergefield firstname \*Charformat} {Mergefield lastname \*Charformat}{Mergefield suffix \*Charformat} and format the fields in the colour you require. You will not be able to format the same fields in different colours according to the dictates of the individual record formatting in Excel. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org xray wrote: Hi, I want to create labels but I want the text color to change based on data in the excel spreadsheet. For instance, I have a row of data with a column that contains a color such as "blue" or "red" and I want the label text color to be that color. Is there a way to do this using MS Word (office 2003)? Example: 4 text fields will print but I want them printed in a color listed in the data. I have a field named "color" so could I do something like: fontcolor = color titlefirstnamelastnamesuffix fontcolor = "black" print rest of fields. (yeah I know it's not proper code but you get the picture Thanks in advance! |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
dynamically formatting text color in mail merge
Well, thanks anyway, but that won't help. I could easily highlight the
fields with a color and get the same result, but I need something more dynamic. I guess it can't be done. Thanks again. "Graham Mayor" wrote: If you want (say) titlefirstnamelastnamesuffix formatted in a colour, then toggle the fields (ALT+F9) to display {Mergefield title}{Mergefield firstname} {Mergefield lastname}{Mergefield suffix} add a Charformat switch to each eg {Mergefield title \*Charformat}{Mergefield firstname \*Charformat} {Mergefield lastname \*Charformat}{Mergefield suffix \*Charformat} and format the fields in the colour you require. You will not be able to format the same fields in different colours according to the dictates of the individual record formatting in Excel. |
#5
|
|||
|
|||
I have a workaround for this.
Use filtering in Excel to isolate the cells you want to color. Add a column and enter a unique identifier for each color (ie. & for red and @ for green) in the appropriate row. When creating your merge, add the identifier to the label or document (We will get rid of it later). Use the "Find" feature in Word to locate all labels or documents that contain the identifier. Click "More", check the box marked "Use Wildcards", then use the replace feature to change the color of the font. When you have completed all of the identifiers then your document or labels should have all the right colored fonts. Use the "Find" feature again to find the identifiers. Click in the replace box and empty it, then click on "No formatting". Click OK and you will remove the identifiers, leaving the labels with the desired color. Quote:
|
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Mail-merge to email looses BG Color on Web-Based Mail | Mailmerge | |||
how do I insert text dynamically | Mailmerge | |||
Embed tables from Access dynamically into Word mail merge letters? | Mailmerge | |||
Grey Background Color Printing during Mail Merge | Mailmerge | |||
Switch an image dynamically based on mail merge field - possible? | Mailmerge |