Can excel send automatic email to outlook

Hi Guys,

I have a spreadsheet with a number of different actions with various different dates associated to them. Is it possible to create a macro that will automatically send an email to my outlook inbox (or somebody elses) when the date is due or upcoming?

Also is it possible to include different content in the email based on say the title of the action etc?

Any help would be greatly appreciated, thanks in advance

Hello gurj_sandhu,

Everything you asked about is possible. Here is a macro to send an email at a particular date and time.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Leith thanks for the response.

Now i have a couple of other questions i have a worksheet which has a number of different actions as i said earlier.

What i am looking to do is if i put todays date in A1, and i have a list of dates in say column X (starting A3, after the column title) can i get excel to go through the whole list in that column (apporx 300) and where the date is 15 days or less than the current date (A1) send an email to an email address which is stored in column A (starting at A3, after column title) and is it possible to have the subject box of the email containing the data in column I and the body of the text reading from column P???

Ive attached a little snashot of my worksheet which may help explain what im looking to do......

Hello gurj_sandhu,

I will look at the workbook and add the macros for you. This will take some time because I have to leave my office for a few hours before I can work on it.

Sincerely,
Leith Ross

That great Leith, appreciate you taking the time to look at it.

Regards,
Gurj

Hey Leith,

Would you have time to asist with another Excel email requeest...

cheers
Rop1

Hello Gurj,

The attached workbook has the email macros installed. I added a button to row 2 on Sheet1 to run the macro. Rows 1 and 2 are frozen so as you scroll those rows they will remain visible.

Outlook Email Macro

Please Login or Register  to view this content.

Command Button Macro

Please Login or Register  to view this content.

Thanks for all your help Leith.

I have tried to run the macro but it highlights the very first line:

"Sub SendEmail(ByVal SendTo As String, ByVal Subj As String, ByVal Msg As String)"
in yellow saying "Compile error: duplicate declaration in scope"

and then highlights the line Msg As String on the line below the first line......

can you help...

Also, regarding the line which determines whether the action is due or not, can we change this to trigger actions which have a due date which is past the date in cell A1 or are coming up to their due date within the next 15 days of the curent date (A1) ....sorry if i wasnt clear in the fist instance.


Thanks

Hello Gurj,

Sorry about the duplicate declarations. That's fixed. The action date is now set to today or 15 days from today. The macro changes are already installed in the attached workbook.

Sincerely,
Leith Ross

Hello All,

I want help to know if excel can send emails to users based on the cell result

For Example

If there are users who need to attempt certain module & we are driving & mapping the completion status.

Is it possible for Excel 2007 or 2003 to automatically send emails to the user if their module completion shows Incomplete or Not Attempted.

Is it possible to set reminders or anything as such.

Awaiting reply.

Thanx