View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Keep formating when mail merging from excel to word address labe

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?