Excel To Outlook mail filtering

[abivanth.r]

Hi
I need to use a excel sheet which has a header “Country Name” it has countries like ‘Argentina’, ‘Chile’, ‘Colombia.’
When I get mail with this country names in subject. I need to filter mails and save the attachments.
Another issue here is each country has many mails like “FW: Argentina Facturación AUG2023”,“Argentina Facturación SEP2023”
Hope the question is clear.
Thanks in advance!

[Vinit_Mhatre (BotBuilder)]

Hi @abivanth.r ,

If you want to filter the mail on subject line you can do as below

"@SQL=(\"urn:schemas:httpmail:subject\" LIKE '%Argentina%')"

"@SQL=(""urn:schemas:httpmail:subject"" LIKE '%"+yourvairable+"')"

Regards,
Vinit Mhatre

[abivanth.r]

Hi I am attaching my .xaml please check once

[Vinit_Mhatre (BotBuilder)]

Hi @abivanth.r ,

Yes Sure

Regards,
Vinit Mhatre

[abivanth.r]

Main.xaml (19.3 KB)

[Vinit_Mhatre (BotBuilder)]

Hi @abivanth.r ,

Could you share me your excel data?

Regards,
Vinit Mhatre

[abivanth.r]

Counrty list 3.xlsx (9.2 KB)

[Vinit_Mhatre (BotBuilder)]

So as per my understanding process is as below tell me if i am not wrong…

1. Read the Excel data with countries.
2. Get the mail data whose subject line contains countries names one by one.
3. save the attachment.

Correct?

[abivanth.r]

yes. but the 1 st country name is argentina. and the mail argentina will eventually go down when other mails comes. so I am getting paused here

[Vinit_Mhatre (BotBuilder)]

So can you tell me how many mails will be there for one Country?

[abivanth.r]

two for argentina, 2 for chile, 4 for colombia. and so on… mails for countries changes

[Vinit_Mhatre (BotBuilder)]

Hi @abivanth.r ,

Try the workflow below; maybe, it will help you. Feel free to ask any questions.

Main.xaml (31.5 KB)

Regards,
Vinit Mhatre

[abivanth.r]

Hi

Getting this error.

[Vinit_Mhatre (BotBuilder)]

Hi @abivanth.r ,

Entire workflow:

Get Outlook mail property:

Regards,
Vinit Mhatre

[abivanth.r]

Getting this error at read range

[Vinit_Mhatre (BotBuilder)]

1. Check excel path
2. Check Sheet name
3. Check Range

[abivanth.r]

Thanks for the help!
Worked

[abivanth.r]

Can I get the Attachments saved in a new folder?
EX: Argentina has 2 mails and each contain 2 attachments. that 4 attachments need to be saved in a folder.
then for chile it has 2 mails and it contain 2 attachments as well. i need to put them in a seperate folder.
like this i need to do it for all country.
is it possible? if it is please help me up
cheers

[Vinit_Mhatre (BotBuilder)]

Hi @abivanth.r ,

Yes you can do that also, just add one condition inside for each as below, it will check every time if folder is exist or not, if not then it will create a folder according to the country name

If condition:

path.Exists("Output\"+item("Country Name").ToString)

At last just pass the “Save_path” variable into save attachment

Regards,
Vinit Mhatre

[abivanth.r]

Hi
The if is little confusing. Can you please share the .xaml