Ask a new question

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
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
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

80 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

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

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated February 28, 2024 Views 29,961 Applies to: