Automating email for 200+ graphs

[Hudson40]

Hi

I have a monthly job to send out 200 + graphs to our internal cutomers. The graphs are produced by me running a query that uses 3 variables - an id, a start date and an end date. I copy and paste the graph to an excel spreadsheet and send to the relevant customer. As you can imagine - its a laborious job. Is there a way I can use a loop to automate this?

Thanks

Andrew

 

[DCrake]

Simple Software Solutions

If you are generating the graph in Access and simply using copy and paste to view it in Excel the Excel spreadsheet will not have a data source.

The MS Knowledge base has examples of how to create a spreadheet through Access that contains a graph. Look at this article and see if it of any use.

CodeMaster: