Hi there,
I got the following problem:
We sent out emails in a campaign. I received a lot of bounces (around 1900 total) which I need to delete from our CRM (Pipedrive).
What I accomplished so far:
- Start Outlook
- Get all emails with the subject containing "undeliverable"
- For each "currentItem" in "RetrievedMails" loop
So far so good. Now I am struggeling with the following. Find the email address in the bounced email body since the bounced email isnt the same as the original email (bounced mails coming from MAILER-DAEMON@... or mailproxy@... or MicrosoftExchange...@....) . I checked some bounced body emails and found out that its normally always the first email mentioned, in some responses its actually mentioned at last.
But how do I do that? I think I got 3 types of bounced email bodys. Maybe we can tell Desktop Flow where to copy a text from exactly? Or maybe we can tell Desktop Flow to look for a hyperlink, edit that text to cut the "mailto:" and copy that email?
Follow up question: If we manage to get the right mail and post it in the search field from Pipedrive, the search function displays the results without having to hit enter. How do I tell Desktop Flow to always click on the first item regardless of the name/email displayed there? It looks like this:
If we manage to get that done like this, I can do the rest on my own. But maybe I'm coming back with some more questions ;-)
Thanks in advance for your help, very much appreciated!