I am trying to figure out how I can set up a code that will send automated emails to a specific group of people based on specific criteria.
I constantly have new clients signed up to courses that run over 5 weeks, each course is made up of of 6 people.
Each group of 6 start their courses on different dates and so each class falls on different dates for every group.
I really want to create a set of emails that would ping out automatically on relevant dates over the 5 week course for all groups, forever more.
The clients are already set up on an excel spreadsheet.
So it would be :
EMAIL AFTER WEEK 1 - don't forget your discount codes etc...
EMAIL AFTER WEEK 2 - how are you? There's 1:1 support available if needed, don't forget if struggling with x,y,z use the handbook etc.
EMAIL AFTER WEEK 3 - (blog links), follow on training course, FB group reminder.
EMAIL AFTER WEEK 4 - thank you, review / testimonial request
Any ideas on how this could work with VBA would be awesome! Ideally it would be triggered by opening the spreadsheet and any emails that need to go would be sent automatically. It would be based on reading multiple date columns in the spreadsheet, the email address would also need to be added as BCC rather than To for GDPR as one email will be sent to multiple email addresses.
I constantly have new clients signed up to courses that run over 5 weeks, each course is made up of of 6 people.
Each group of 6 start their courses on different dates and so each class falls on different dates for every group.
I really want to create a set of emails that would ping out automatically on relevant dates over the 5 week course for all groups, forever more.
The clients are already set up on an excel spreadsheet.
So it would be :
EMAIL AFTER WEEK 1 - don't forget your discount codes etc...
EMAIL AFTER WEEK 2 - how are you? There's 1:1 support available if needed, don't forget if struggling with x,y,z use the handbook etc.
EMAIL AFTER WEEK 3 - (blog links), follow on training course, FB group reminder.
EMAIL AFTER WEEK 4 - thank you, review / testimonial request
Any ideas on how this could work with VBA would be awesome! Ideally it would be triggered by opening the spreadsheet and any emails that need to go would be sent automatically. It would be based on reading multiple date columns in the spreadsheet, the email address would also need to be added as BCC rather than To for GDPR as one email will be sent to multiple email addresses.
