VBA code to send mail automatically from outlook

Hi excel gurus,

Kindly anyone help me pls.

I need to send a mail on a daily basis from outlook at 6.00 pm.
Containing a shared link to particular mail I'd.

If we can write a macro for sending the mail automatically would be of very great help as we are missing to send the mail some times.

Thanks in advance

Regards,

Aravind

Attached a sample workbook. Go through the code and update data in relevant cells.
PS: Use Windows schedulers to run the code at fixed timeline

Hi,

I tried running the it seems not working. Kindly help there is no error message coming.
But the mail also not getting triggered .
And also where do I find the windows scheduler.

Thanks in advance

Regards

Aravind

To execute VBA: attach your workbook with sample data.
Windows Task: Start->All Programs->Accessories->System Tools->Scheduled Tasks

Hi,

Thanks for the help.

Sorry for the inconvinence caused.

However what should I put in function/location/planned effort/actual effort/ status .

Do I need to fill all the cells. If left blank will the macro work.

Thanks in advance.

Regards,

Aravind

Hi,

Thanks for the help.

Sorry for the inconvinence caused.

However what should I put in function/location/planned effort/actual effort/ status .

Do I need to fill all the cells. If left blank will the macro work.

Thanks in advance.

Regards,

Aravind

Try:

PS: this is sheet which I am using for my reference on daily basis. Please make changes this code to your requirements.

In Col A: Fill the name of the recipient
In Col D: Email id of the recipient
In Col F: CC of the person/s
In Col I: Mail has to send? or not?. (i.e Let us Consider many rows are there in your sheet, in that, if you want to send mail the put"YES" else put "NO"
Then,
Press Alt+F8 and run the macro called "Send Email"

Thanks a lot the macro is working fine.

But I tried scheduling this in windows but the mail is not getting triggered .

Kindly help please sorry for the inconvinence .

Thanks a lot

Could you please give me the code to trigger the event.