Email macro

[danweeks20]

Hi all,

If someone can help me that would be really appreciated. I have several workbooks on a sharepoint, and need a couple of things;

1. There are numerous spreadsheets on the sharepoint, column 1 has a date within it, is there a way to have an automatic process that would check all spreadsheets daily and send an email to alert there are jobs pending. Can this be done without opening the spreadsheet itself?

2. I need to be able to email to various people data from indididual rows. Is there a way to select a row click a button (macro) and send the data, leaving the "to" blank? I.e. Column 10 has notes in it, but would like to include data from all rows so it would look something like:

DATE: "insert date from spreadsheet"
JOB NUMBER:
COMPANY:
NOTES:

etc etc

Any help much appreciated.

Thanks DJ

[Ananyaa]

Using Macro Tool, you can automatically complete these tasks at the same time without your interfere. You could edit macro script and set a hotkey for each one. So when you wanting to log into your company account or email account, or other things, just press one hotkey lightly, Macro Tool will do for you automatically. If it's necessary, you could set an exact time for performing to log into your email, or other things.Are you looking for more information about the new list best email software............