Keep formating when mail merging from excel to word address labe

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

timfitz - 06 Jul 2006 03:39 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 06 Jul 2006 04:07 GMT

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.

Signature

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

> Trying to mail merge. Excel spread sheet with some conditional formating
> in
[quoted text clipped - 4 lines]
>
> Any ideas?

Reply to this Message

Peter Jamieson - 06 Jul 2006 07:54 GMT

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

> Trying to mail merge. Excel spread sheet with some conditional formating
> in
[quoted text clipped - 4 lines]
>
> Any ideas?

Reply to this Message