I have a document on excel which I am mailmerging and it has coloured text.
how do I bring this coloured text onto the mailmerge

You can control the way in which all of the text for an individual
mergefield is displayed for all of the records by adding a \*charformat
switch inside the closing } of the Mergefield (use Alt+F9 to toggle the
display of field codes) and then applying the desired font format to the M
of Mergefield.

To an extent, you can control the way that the text of an individual
mergefield is displayed for individual records by use of an If...then...else
field that returns the desired mergefield for both the true and false
condition and by adding the \*charformat inside the closing } of each of the
result mergefields and applying the appropriate formatting to the M of each
result. In this way, you could have positive numbers displayed in black and
negative numbers displayed in red.

{ IF { MERGEFIELD Balance } 0 { MERGEFIELD Balance \*charformat } {
MERGEFIELD Balance \*charformat } }

In the above example, you would format the M of the second instance of
MERGEFIELD so that the font is Red.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"sharon2005" wrote in message
...
I have a document on excel which I am mailmerging and it has coloured text.
how do I bring this coloured text onto the mailmerge