merging highlighted data from excel

[betzp]

I have formatted my excel spreadsheet with highlighting and text color.
However, when I mail merge data from my excel spreadsheet to make labels,
none of the formatting transfers- only the data. Is it possible to merge
the colors too?

 

[Peter Jamieson]

Mailmerge doesn't bring that kind of formatting information over from
any data source, but a "trick" you may be able to use to transfer some
of the formatting information is as follows:

Select the data on your Excel sheet and copy/paste it into a new Word
document.

Use that document as your mail merge data source.

Insert your mailmerge fields into the first label in the usual way.

Press Alt-F9 to show the underlying fields, e.g.

{ MERGEFIELD "myfield" }

and change the MERGEFIELD to REF so you have

{ REF "myfield" }

Propagate the fields in the usual way, then merge to a new document and
see what formatting is carried over. That seems to work with text colour
but I would not expect it to work with the ackground colour for the
entire cell

Peter Jamieson

http://tips.pjmsn.me.uk

 

[betzp]

Thank you for that post, it works well! Unfortunately I am trying to
simplify the process, so if I cannot get the colors to merge, then I will
leave them out.