Hi, Jellis. Welcome to the board.
Meltdown is referring to Microsoft's Technet, which can be found here:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;kbhowto&sd=TECH&ln=EN-US&FR=0
You may want to bookmark that site.
Once you're at that site, you can type the Q-number into the box at the top left and it'll show you that article.
Using automation is one hellatious (did I spell that right?) thing to have to learn. And you'd be hard-put to learn it within a reasonable amount of time. Not only would you have to learn the basics of Excel VBA, but of Outlook as well. Excel is the most commonly automated Office application, and Outlook is probably the least common--maybe PowerPoint, hee hee.
Anyway, I just happen to have some code that will allow you to select cells and hit a button. Those cells are copied to a new Workbook, saved, and then emailed as an Excel file attachment to the person defined, using subject, etc., all defined in the code.
However, it is not automated to occur every XX time increment. I've just asked my husband (very nicely, for your sake) to change the code in that workbook to allow you to choose 4 specific cells (so you don't have to select them every time) and get it to work on a time increment. He won't be able to get it to work if you have the Excel file closed (others could definitely do this), but he can likely get it to work off the system clock and do it for you once per hour.
Let's see what he comes up with, k? Might take a day or two, or even more. It'd be helpful if he had your email address to. You can email him at
[email protected] to give him all your specifics. That'd be great. When we're all done doing it, we can post the final code here for all to see.
