[timfitz]

Trying to mail merge. Excel spread sheet with some conditional formating in
certain fields. When merged the text format is lost. I found out how to set
the field format for every name merge. But it does not come across as it
looks in excel.(red or green or bold).

Any ideas?

[Doug Robbins - Word MVP]

You may be able to do it by using and If...then...Else field construction in
Word to apply the condition with the \* charformat switch appplied to the
{ Mergefield } in the results, applying the required font formatting to the
M of mergefield in each case.

--
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

"timfitz" wrote in message
...
Trying to mail merge. Excel spread sheet with some conditional formating
in
certain fields. When merged the text format is lost. I found out how to
set
the field format for every name merge. But it does not come across as it
looks in excel.(red or green or bold).

Any ideas?

[Peter Jamieson]

It may be worth trying the following if your Excel sheet has fewer than
(arond) 64 columns:
a. select your Excel sheet
b. copy/paste into a Word document so that formatting is retained
c. use the Word document as the data source
d. for fields where you wish to retain formatting, instead of { MERGEFIELD
X } use { REF X } or just { X }.

Some formatting comes through when you do that but I haven't tested the
specifics in this case.

Peter Jamieson

"timfitz" wrote in message
...
Trying to mail merge. Excel spread sheet with some conditional formating
in
certain fields. When merged the text format is lost. I found out how to
set
the field format for every name merge. But it does not come across as it
looks in excel.(red or green or bold).

Any ideas?