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 wrote:
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?