Re: dynamically formatting text color in mail merge

Tech-Archive recommends: Fix windows errors by optimizing your registry

If you want (say) <<title>><<firstname>><<lastname>><<suffix>> 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 spread***.

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>>
<<title>><<firstname>><<lastname>><<suffix>>
fontcolor = "black"
print rest of fields.

(yeah I know it's not proper code but you get the picture :)

Thanks in advance!


.

Quantcast