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
|
|||
|
|||
Different graphic for each record in mail merge document
I have 2000 lines in excel which is used to make a merge doc. In the mail
merge document, I want to have a graphic associated with each record. How can I modify the merge to make in sort that the graphic will change for each excel line (simultaneous during the merge process). What I have done is the following: 1- I have created a chart for each record in excel. 2- I have added a column to the data table and enter the name of the appropriate chart for each record. 3- I have linked the graphic of the line 2 (the first one) in the mail merge document but doing a paste with link. So, when I merge the document, all the data change but not the graphic. Does anyone know how to have a graphic that vary in function of the merge field (which is the name of the graphic in excel)? Thank you, -- Alex St-Pierre |
#2
|
|||
|
|||
Did you ever get this to work? I am trying to do the same thing. How did
you create separate charts for each record? Did you do them one at a time? "Alex St-Pierre" wrote: I have 2000 lines in excel which is used to make a merge doc. In the mail merge document, I want to have a graphic associated with each record. How can I modify the merge to make in sort that the graphic will change for each excel line (simultaneous during the merge process). What I have done is the following: 1- I have created a chart for each record in excel. 2- I have added a column to the data table and enter the name of the appropriate chart for each record. 3- I have linked the graphic of the line 2 (the first one) in the mail merge document but doing a paste with link. So, when I merge the document, all the data change but not the graphic. Does anyone know how to have a graphic that vary in function of the merge field (which is the name of the graphic in excel)? Thank you, -- Alex St-Pierre |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge for Catalog document | Terry | General Discussion | 1 | July 27th, 2004 05:33 AM |
Mail Merge Problem | MT DOJ Help Desk | General Discussion | 7 | July 20th, 2004 08:02 AM |
Total number of pages in mail merge document per document | Ava Healy | Mailmerge | 1 | May 27th, 2004 06:50 AM |
Using a Excel macro or VB to call up a WORD mail merge document | Bob Reynolds | Worksheet Functions | 0 | January 7th, 2004 06:25 PM |
Mail merge Excel database to Excel "document" | Rick | Setting up and Configuration | 0 | October 29th, 2003 06:29 PM |