email integration and report gneration from a spreadsheet

[hellcat83]

Hi folks.

I'm investigating the possibilities of extending a spreadsheet I've been working on to manage data in a school.

I've already completed the first stage of the process, creating the management system on a spreadsheet, but ideally I'd like to generate weekly reports of recent data from the sheet that are emailed to staff.

I know that there's a lot of cross functionality in microsoft office, but can you schedule anything like this using outlook and excel together?

Thanks

 

[Smitty]

Sure,

Check out www.rondebruin.nl/sendmail.html

He's got plenty of code for e-mailing Excel workbooks/data with Outlook.

You can also automate tasks with Windows Scheduler.

All you need to do is use the Workbook_Open event to fire the code you want when Scheduler opens a workbook.

HTH,

 

[hellcat83]

Thanks for the pointers, some good places to get started from.

Jim