Read excel and send email

Help
, , ,
1

Hi Friends,

Good day !! Its quite urgent. Kindly help me with this.

can anyone help me to accomplish the below.

  1. I have an excel as below,

image

  1. I have email ids in an another excel
    image

I want to send email to Each Vendor with attachment that contains only that vendors records.

To : A@gmail.com
CC:XX@gmail.com
Attachment:
image

To:B@gmail.com
CC:YY@gmail.com
Attachment:
image

2

Hello,

I would says that you could

  • Transform your Excel Files as datatable

  • Merge them by using the column “vendor” as unique key

  • Filter your datatable for each vendor and create Excel file with unique name into a for each and send emails

This is a high level design that I hope it will help you.

3

Hi @oshan,
EmailFilteredData.zip (14.3 KB)
Please find attached xaml.

Thanks,
shobhit

4

thank you so much

5

you really saved me… thanks a lot :slight_smile:
i will try this and get back shortly.