Forum Discussion
Automated Emails
Hi everyone, I was able to work out how to get Microsoft Excel to send automated reminder on certain dates. However, I was wondering if I was able to specialize the email so it reminds me of a ce...
You might create a list with two columns: dates in the first column and keywords in the second column.
You can then look up the current date in the first column, take the corresponding keyword in the second column, and insert that into the body of the message.
Sorry, I just have another question. How do I set the VBA code to only send the email on a specific day?
Do you want to send it on a specific date, e.g. 10-Jan-2023, or on a specific day of the week or month?
HansVogelaar I would like to send it on a specific day but all the days will be different. I was trying to put the days in a cell just like the keyword but unsure how to get the email sent on that specific day.