mugiwara21
New Member
- Joined
- Feb 17, 2019
- Messages
- 1
[FONT="]Ok guys, this might take some time, so please bear with me.[/FONT]
[FONT="]
[/FONT]
[FONT="]Is it possible to create a macro that would run everyday (either automatically or when prompted by me) and resend a reminder e-mail?[/FONT]
[FONT="]
[/FONT]
[FONT="]I would have the outlook message saved in a folder and have a cell on the excel table with the path to that file. The macro, when run, would look for both the value in a column called reminder, and if that value is "Yes" and the value on the Customer Reply column is "No" would re-send the e-mail on the E-mail file path (or foward it to the same recipients as the first e-mail with a body text like "kindly reminder" (but I would work on the body of the e-mail later) and automatically update the date to the current date (date of the day where it was re-sent - to avoid being re-sent everyday, and only be resent again after 30 days again, if we still have no answer).[/FONT]
[FONT="]
[/FONT]
[FONT="]So, take the example below:[/FONT]
[FONT="]https://imgur.com/a/Hu0w3oc[/FONT]
[FONT="]
[/FONT]
[FONT="]If for example I had a macro that could this and would run it today, and we have two "reminders" with "yes". but since only of them has the value "no" for customer reply, only that e-mail would be resent again. And the Date would be with updated to today's date, to avoid the e-mail to be resent again tomorrow when I run the macro.[/FONT]
[FONT="]
[/FONT]
[FONT="]Is this possible?[/FONT]
[FONT="]
[/FONT]
[FONT="]Sorry for the long post and my english and thanks in advance[/FONT]
[FONT="]
[/FONT]
[FONT="]Is it possible to create a macro that would run everyday (either automatically or when prompted by me) and resend a reminder e-mail?[/FONT]
[FONT="]
[/FONT]
[FONT="]I would have the outlook message saved in a folder and have a cell on the excel table with the path to that file. The macro, when run, would look for both the value in a column called reminder, and if that value is "Yes" and the value on the Customer Reply column is "No" would re-send the e-mail on the E-mail file path (or foward it to the same recipients as the first e-mail with a body text like "kindly reminder" (but I would work on the body of the e-mail later) and automatically update the date to the current date (date of the day where it was re-sent - to avoid being re-sent everyday, and only be resent again after 30 days again, if we still have no answer).[/FONT]
[FONT="]
[/FONT]
[FONT="]So, take the example below:[/FONT]
[FONT="]https://imgur.com/a/Hu0w3oc[/FONT]
[FONT="]
[/FONT]
[FONT="]If for example I had a macro that could this and would run it today, and we have two "reminders" with "yes". but since only of them has the value "no" for customer reply, only that e-mail would be resent again. And the Date would be with updated to today's date, to avoid the e-mail to be resent again tomorrow when I run the macro.[/FONT]
[FONT="]
[/FONT]
[FONT="]Is this possible?[/FONT]
[FONT="]
[/FONT]
[FONT="]Sorry for the long post and my english and thanks in advance[/FONT]