If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Carrying Excel cell properties into word when mail merging
I have an excel document with some cells that contain colour others which
contain background shading. I would like to be able to create a mail merge document in word that picks up the data from this excel file and carries with it all the cell information i.e. font size, font colour, font type,background colour etc as well as the cell value, and places all of that information into word. It appears as though you only get the cell value. Any help would be greatly appreciated. |
#2
|
|||
|
|||
You can get at least some of the text attributes (font, fontsize) through
using a trick: a. edit|copy your sheet and edit|paste special into a blank Word document using a format that retains the properties (probably Formatted RTF). b. Instead of using { MERGEFIELD myfield } in your mail merge main document, use { REF myfield } or just { myfield } if there is no clash with the name of a field type. However, to retrieve the cell formatting as well I think you would have to consider generating your Word document using automation (e.g. using Excel VBA) rather than using MailMerge, and even then you would probably only be able to get cell backgrounds by using table cells, or perhaps converting the cells to images or text boxes. Not something I'd want to try to get right :-) Peter Jamieson "RIPage" wrote in message ... I have an excel document with some cells that contain colour others which contain background shading. I would like to be able to create a mail merge document in word that picks up the data from this excel file and carries with it all the cell information i.e. font size, font colour, font type,background colour etc as well as the cell value, and places all of that information into word. It appears as though you only get the cell value. Any help would be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
is word perfect compatible with office word? | Noreen | General Discussion | 1 | May 11th, 2005 11:17 PM |
How do I create & merge specific data base & master documents? | maggiev | New Users | 2 | January 12th, 2005 11:30 PM |
Excel worksheet in Word linked text boxes | Eduardo Oliveira | Page Layout | 0 | January 5th, 2005 11:23 PM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
Problems : cannot open mail with attachments- Word, Excel etc | sarah rosen | General Discussions | 3 | June 16th, 2004 03:16 AM |