A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Different graphic for each record in mail merge document



 
 
Thread Tools Display Modes
  #1  
Old November 28th, 2004, 05:03 PM
Alex St-Pierre
external usenet poster
 
Posts: n/a
Default 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  
Old May 4th, 2005, 07:26 PM
Dede
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.