Originally Posted by
Kenneth Hobs
While we could import your data to Excel and make the chart, is it worth it? You then have to make sure that they have Excel.
You can probably do it all in Access's vba. In Excel, we can export the chart to a filename.
e.g.
[vba]Worksheets("Sheet1").ChartObjects(1) _ .Chart.Export _ FileName:="current_sales.gif", FilterName:="GIF" [/vba]
I'm sure Access has something similar. Your vba code in Access can then email the file as an attachment.
However, if you still want to use Excel, let us know. A sample Access file will be needed.