How to fetch mails for yesterdays date. Get Mail messages Filter ANSWSER

News Vote on Tutorials
, , ,
1

Hello everyone,

Since I didn’t find something similar and saw it several times, but cannot answer to older posts great than 3 days, here is a short answer how to filter all mails for the exact day.
You need to add the hours and minutes in the Get Outlook Mail Messages activity filter:

" [ReceivedTime] <=‘" + datetime.Now.AddDays(-1).ToString(“dd.MM.yyyy 23:59”) + "’ AND [ReceivedTime] >=‘" + datetime.Now.AddDays(-1).ToString(“dd.MM.yyyy 00:00”) +"’"

Here you will get all mails received from todays day. Then you loop through it System.net.mail.mailmessages and you can proceed with other activities like get the attachments and so on.

2

To fetch emails for yesterday’s date using UiPath, you can indeed use the Get Outlook Mail Messages activity with a specific filter in the properties panel. The filter you have mentioned is almost correct; however, you must ensure that the date format and the escape characters are used correctly within the filter string.

Here’s how you can set it up in UiPath:

  1. Use the Get Outlook Mail Messages activity.
  2. Set the properties of the activity as follows:
  • MailFolder: “Inbox” (or another folder if needed)
  • Filter: The filter string to get emails from yesterday

The filter string should be written as follows in VB.NET syntax:

“[ReceivedTime] >= '” + Now.AddDays(-1).ToString(“dd/MM/yyyy 00:00”) + “’ AND [ReceivedTime] <= '” + Now.AddDays(-1).ToString(“dd/MM/yyyy 23:59”) + “'”

Make sure to use the correct date and time format that Outlook expects, which is typically MM/dd/yyyy HH:mm if your system is set to the US locale. The format "dd/MM/yyyy HH:mm" would be used for locales that use the day-month-year format.

After setting this filter, the activity will only retrieve emails that were received during the previous day.

Here’s the full workflow step by step:

  1. Assign Activity*: Assign yesterdayStart with Now.AddDays(-1).Date to get the start of yesterday.
  2. Assign Activity*: Assign yesterdayEnd with Now.AddDays(-1).Date.AddDays(1).AddMinutes(-1) to get the end of yesterday.
  3. Get Outlook Mail Messages Activity*:
  • Set the Filter property to:

“[ReceivedTime] >= '” + yesterdayStart.ToString(“MM/dd/yyyy HH:mm”) + “’ AND [ReceivedTime] <= '” + yesterdayEnd.ToString(“MM/dd/yyyy HH:mm”) + “'”

  • Set other properties as required for your process.
  1. For Each Activity*: Loop through the emails and process them as needed.
3

Hello. The same problem occurred. I’ve been looking for a solution for a long time. I managed to find your topic here and I’m glad that you received an answer here too, since you don’t ask any more questions, it helped you in solving your problem. It’s very nice that there are knowledgeable people, Thank you

4

@Nessundorma This thread contains tons of info about how to create queries.

2 Likes