Mailmerging to Word

[Adam]

Hi Guys,

I posted the below post in the Word newsgroup however have not had an
answer, so I'm guessing that this might be more of an Excel guru's
question:


Please can someone help with the below? This is majorily importance and
could mean the difference between me manually colour coding 10730
fields myself!



Newsgroups: microsoft.public.word
From: "Adam" <[email protected]> - Find messages by this author
Date: 10 Jan 2006 12:38:04 -0800
Local: Tues, Jan 10 2006 8:38 pm
Subject: Conditional Formatting?
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

Hi Guys,


I'm a Word newbie as I tend to spend most of my time in Excel and
Access, so please forgive me if this is a stupid question.


I'm completing a mail merge in work whereby I'm taking loads of fields
from a spreadsheet and placing them in a mail merged word document.


I want to apply conditional formatting on some of the merged fields,
whereby if the field is less than a figure, its coloured Red and if its

greater then it is coloured green.


Can this be done?


Many Thanks!


Adam

 

[SamuelT]

The following link might be of some use...

http://www.gmayor.com/formatting_word_fields.htm

 

[Adam]

Thank you but this still only looks at the format displayed and not how
to colour the merged field depending on a condition.

 

[Dave Peterson]

First, I don't have a good answer...

But maybe you could ask in the MSWord newsgroups (or maybe someone will post a
reply here???) if you can pass an extra field in the mailmerge and use that in
the formatting of that other field.

You could add a column of formulas:
=if(a2<5,true,false)

This article describes how to use Mergefield in MSWord.
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

I have no idea if you can change colors using this technique--back to the MSWord
newsgroups???