Since UiPath Studio Send Outlook Mail Activity does not have a delay to send an email. I thought if a robot is able to use the Microsoft Outlook Delay Delivery function.
I have done the following as I create the birthday email as a draft using Send Outlook Mail Activity. Then use get outlook mail message and filter only subject title of “Happy Birthday”. Move the filtered email subject to a new folder “Birthday Greeting”.
From here, the robot will open the Outlook application. Click on the folder “Birthday Greeting” and click on the first email at the top of the folder. Then click on the “Pop Out” button of that email, click the “Options” tab, and “Delay Delivery” option.
Then this properties window will appear.
The problem is how do the robot match the email under the “Birthday Greeting” folder with the birthdate in the excel file. Currently, the robot loops the birthdate as a variable from the excel file in the highlighted drop-down list and only stop at the last birthdate in the excel file. I want the robot to only type into the birthdate of the specific user to their specific email.
If the robot were to run once a week on Monday, it checks if the birthdate in the excel file is on Tues, Wed, Thurs and Fri.