Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging highlighted data from excel
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging highlighted data from excel
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? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging highlighted data from excel
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. "Peter Jamieson" wrote: 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems Merging Data from Excel to Word for MAC | Mailmerge | |||
Not merging all records from an Excel data source | Mailmerge | |||
Merging data from Excel to Word | Microsoft Word Help | |||
Merging Data from Excel into words | Mailmerge | |||
How do you keep the currency format when merging data from Excel? | Mailmerge |