Hi
I am hoping that someone will be able to help me with a spreadsheet query regarding Excel VBA.
I have a spreadsheet that contains the following date:
Date Joined Name Date to be automatically enrolled Email Address Need to set reminder
25/04/2018 Sue 16/05/2018 abc@xyz.com send email
30/04/2018 Lenny 30/07/2018 abc@xyz.com
30/04/2018 Subo 30/07/2018 abc@xyz.com
30/04/2018 Suwo 16/05/2018 abc@xyz.com send email
30/04/2018 Sandra 17/05/2018 abc@xyz.com
30/04/2018 Lindz 30/07/2018 abc@xyz.com
When someone joins the organisation I need to work out what the date is 3 months from the date of joining and it needs to automatically appear in column C - (date to be automatically enrolled).
Once the date in column C is equivalent to todays date, I need to generate an email to each person whose enrollment date is today.
The subject of the email should be: Pension Enrolment
Body of email should be: Dear [name] - this is taken from column B.
You are now enrolled onto our company pension scheme.
If you wish to opt out please let us know.
Regards
Sign off: Management Team
I also need to put my own email address into the BCC field so that I have a log of the email sent.
Once the email is sent I need the cell containing the email address to go red so that I can see it has been actioned.
Can someone please help with this.
Thanking you all kindly in advance.
Regards
Sue
I am hoping that someone will be able to help me with a spreadsheet query regarding Excel VBA.
I have a spreadsheet that contains the following date:
Date Joined Name Date to be automatically enrolled Email Address Need to set reminder
25/04/2018 Sue 16/05/2018 abc@xyz.com send email
30/04/2018 Lenny 30/07/2018 abc@xyz.com
30/04/2018 Subo 30/07/2018 abc@xyz.com
30/04/2018 Suwo 16/05/2018 abc@xyz.com send email
30/04/2018 Sandra 17/05/2018 abc@xyz.com
30/04/2018 Lindz 30/07/2018 abc@xyz.com
When someone joins the organisation I need to work out what the date is 3 months from the date of joining and it needs to automatically appear in column C - (date to be automatically enrolled).
Once the date in column C is equivalent to todays date, I need to generate an email to each person whose enrollment date is today.
The subject of the email should be: Pension Enrolment
Body of email should be: Dear [name] - this is taken from column B.
You are now enrolled onto our company pension scheme.
If you wish to opt out please let us know.
Regards
Sign off: Management Team
I also need to put my own email address into the BCC field so that I have a log of the email sent.
Once the email is sent I need the cell containing the email address to go red so that I can see it has been actioned.
Can someone please help with this.
Thanking you all kindly in advance.
Regards
Sue
Last edited by a moderator:
