My goal is to create a VBS script that will email users automatically about their item when a specific date is hit.
I have the User 1, User 1’s Email, Item Name, due date, and an IF statement that states if (TODAY), done, not done. (Done = emailed by system, not done = not emailed by system. Different users will have different items, so the code will need to reference certain cells.
Id like the email to say:
‘Hello (user #),
We noticed you have (item name(s)), etc.’
How can this be accomplished?
I have the User 1, User 1’s Email, Item Name, due date, and an IF statement that states if (TODAY), done, not done. (Done = emailed by system, not done = not emailed by system. Different users will have different items, so the code will need to reference certain cells.
Id like the email to say:
‘Hello (user #),
We noticed you have (item name(s)), etc.’
How can this be accomplished?
