Reminder Email to ID's in the range along with details in Cells using VBA

[Diraviyam]

Hi All,

I have been breaking my head on this code for about a week now. All i wanted to do was to create a reminder email using VBA with the following criteria;

- The email IDs are available in a particular cell in all the sheets

- The activity due date mentioned in a particular cell in all the sheets

- On weekly basis an email must be sent out to all the resources who are assigned to complete a task in that particular week

- Also, the 'Backlog' from the previous week (based on the 'Activity Status & Rescheduled Date') an email must be generated and sent to the users

Note: Mail app: OutLook
MS Office: Office 365

I have attached a model file along with this tread. Hoping i would also be helped by the VBA masters in this forum - like the way others have been helped.


Regards,
Diraviyam

 

[Mike H..]

Hi All,

I have been breaking my head on this code for about a week now. All i wanted to do was to create a reminder email using VBA with the following criteria;

- The email IDs are available in a particular cell in all the sheets

- The activity due date mentioned in a particular cell in all the sheets

- On weekly basis an email must be sent out to all the resources who are assigned to complete a task in that particular week

- Also, the 'Backlog' from the previous week (based on the 'Activity Status & Rescheduled Date') an email must be generated and sent to the users

Note: Mail app: OutLook
MS Office: Office 365

I have attached a model file along with this tread. Hoping i would also be helped by the VBA masters in this forum - like the way others have been helped.


Regards,
Diraviyam

Hi,

You can find all the methods here.

http://www.rondebruin.nl/win/s1/outlook/mail.htm

 

[Diraviyam]

HI Mike, thanks for your prompt reply... I had tried that earlier, but had hic-cups in having the codes to read the conditions and emails from each sheets L Would try again.