Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mailmerge colours
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 |
#2
|
|||
|
|||
mailmerge colours
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge | Mailmerge | |||
Trying to suppress Select Table box in Excel-Word mailmerge | Mailmerge | |||
Protect mailmerge document | Mailmerge | |||
Textboxes in Mailmerge? | Mailmerge | |||
Included Property in Word 2003 MailMerge | Mailmerge |