I have an Excel spreadsheet that has records for 500 people in one tab. In the next tab there is a dynamic chart. We are doing a mail merge with a Word document and want to include the customized chart with each Word document that the mail merge produces. Is it possible to do this? And if so would it be better to use an Excel macro to put the chart into Word, or set up the chart in the Word document and have the mail merge feed data into the chart?
I think the best approach is to control via code within excel the population of a word document(s) with inserted images of the chart.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks