Auto Update Macro - Copy/Paste Send Email

[djfatboyfats]

HI all

I have a main spreadsheet that we have to manually update each hour and send out the results to a distribution list via email, what i want to know is if we can get this automated so that it will automatically update, copy the data and send via email without no manually intervention

The cells i need to copy are

Workbook Name - "March 09"
Worksheet Name - "24"
Email - "Outlook 2003"
Cells to copy - A3:F36

Thanks in advance

DJ

[nomel]

So, you want to grab the values from the range that you specified, and send them out in an email as a workbook?

[djfatboyfats]

In a workbook or just pasted into a new message via outlook, can this be done?