Mail Merge with Excel Charts

HI,
I need to execute mail merge with excel charts, there are 100+ records in excel. 
Based on certain data field i need to create a pie chart. 
Using mail merge i am expected to have different pie chart for each record
Is their any way to create this functionality in office 2010 ???
Regards
Ankit
 

Question Info


Last updated February 11, 2020 Views 25,070 Applies to:
Answer
Answer
HI,

I need to execute mail merge with excel charts, there are 100+ records in excel. 

Based on certain data field i need to create a pie chart. 

Using mail merge i am expected to have different pie chart for each record

Is their any way to create this functionality in office 2010 ???

Regards

Ankit

Download the MergeTools – 20120609 Add-in that I created from the following page of my Windows Live SkyDrive:

https://skydrive.live.com/?cid=5aedcb43615e886b#cid=5AEDCB43615E886B&id=5AEDCB43615E886B%21111

and also the Mail Merging with Charts document that is also on that page.  That document explains how you must set up the Excel Data Source and the Mail Merge Main document to be able to execute a merge with a Chart that is unique to each record in the data source.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
Screen shots by Snagit from www.techsmith.com

79 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.