Word 2000 - Merge If

  • Thread starter Thread starter Carolyn Marshall
  • Start date Start date
C

Carolyn Marshall

I've done Merge If's but this time I need to do a merge If
an entre = chicken, the text is green; if beef, red; if
fish, blue.

I've done a VBA project where I applied a style to color
the text if certain conditions were met, but am not sure
about a merge.

Carolyn Marshall
(e-mail address removed)
 
Be aware that studies reveal that 20% of men are unable to read green text.
Blue and black text is preferred.

Not that you asked, but I find very colorful text garish and distracting.

Just my $0.02 worth. (I can't find the "cents" character.)
 
Hi Carolyn,

Place the text inside or the mergefield containing the text inside { QUOTE }
fields to which you add the \* CHARFORMAT switch and apply the desired font
colour to the Q of Quote.

For example with the following field construction

{ IF 1 = 1 { QUOTE { MERGEFIELD "FirstName" } \* CHARFORMAT } { QUOTE {
MERGEFIELD "FirstName" } \* CHARFORMAT }}

If the Q in the first QUOTE is formatted as Red and that in the second is
formatted as Green, the data from the FirstName field appears in Red.

If you change it to

{ IF 1 = 2 { QUOTE { MERGEFIELD "FirstName" } \* CHARFORMAT } { QUOTE {
MERGEFIELD "FirstName" } \* CHARFORMAT }}

the data from that field appears in Green.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 
Back
Top