Automatically run query in Excel and send email?

reefoid · 14 Oct 2010 at 11:00

I have a spreadsheet that runs a query against a FoxPro database. At the moment, I have to open Excel, refresh the data and I then email the workbook to various recipients.

Does anyone know of a way I can automate this process? For example, at 4 p.m. each day the spreadsheet would automatically open, refresh the data and then email itself? Sounds like a bit of a tall order, but is this possible?

Thanks

reefoid · 14 Oct 2010 at 11:19

I'm using Outlook. We have both 2003 and 2007, but a solution for just one of these will be good. How have you got it working with Lotus?

reefoid · 14 Oct 2010 at 11:22

Thanks, will take a look.

reefoid · 14 Oct 2010 at 13:36

I can get the spreadsheet to open automatically using Windows task scheduler. I've taken a look and I'm pretty sure VBA can do the rest. Will give it a go this afternoon, but may be back with questions.

Cheers.