Mail Merge Excel Chart

[canucklady]

I am not sure if this is possible.

I have a spreadsheet with Employee Data. I am able to merge the data into a form letter, that is fine.

Now my boss wants me to add a chart from the merged data.

Is there a way to do this.

[MOS MASTER]

Hi canucklady, :hi:

Merging pictures or OLE objects is one of those things Mailmerge cannot do directly.

However there are some workarrounds that could work for you as well.
Cindy Meister (Word MVP) has a nice workarround on here website:
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

This could work well with an excel document as well.
What you need to do is add a new column to your excel file with the picture name of your exported graph.

And you need to export your graph as picture to that location. (this could be done by code and you could open up a new question for this in the Excel forum)

So if you change your excel file a bit then I think it should work. Good luck!

HTH

[MOS MASTER]

canucklady, did my answer help you or do you still have questions?

[canucklady]

I am not sure how to add the picture name to the column?

I have a graph for every record(row) of employees.

[MOS MASTER]

Hi,

If you have a different graph for each merge record then I think you need to go first to the Excel forum to get something like this:

1. For each record export the graph to something like: C:\graphs
2. Give the graph a unique name and fill the name into a column. (graphcolumn)

then you have the pictures of the graph available and you can use the above tip I gave you with a fieldcode like:
{ IncludePicture "C:\\graphs\\{ Mergefield graphcolumn }" }

HTH