Different graphic for each record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex St-Pierre - 29 Nov 2004 15:13 GMT

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,

Signature

Alex St-Pierre

Reply to this Message

Doug Robbins - 30 Nov 2004 01:06 GMT

See the "Include graphics from database" item under the "Special merges"
section
of fellow MVP CIndy Meister's website at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>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
[quoted text clipped - 16 lines]
>
> Thank you,

Reply to this Message