Chris Wright
New Member
- Joined
- Feb 3, 2009
- Messages
- 7
I have an Excel spreadsheet that is used as the data source for some mail-merged reports.
The report includes an Excel chart.
The mail-merge steps through the selected Excel records for each report, but I would also like to update the Excel chart with each report using data from the same records.
Is this possible without running a VBA macro to generate multiple charts and then copying them into the mail-merge generated reports?
The report includes an Excel chart.
The mail-merge steps through the selected Excel records for each report, but I would also like to update the Excel chart with each report using data from the same records.
Is this possible without running a VBA macro to generate multiple charts and then copying them into the mail-merge generated reports?