Send emails from excel data

Help
, ,
1

Hi,
I need to send separate emails
image
The requestor will be the same in the To section of the email but as there are two unique emails each email id needs to be in cc with the invoice number in the emails.

Thanks

2

Hi @Rishi_Mukherjee

so you want to send only two mails as there are only two unique customer email value ??
if yes how you want to send invoice no.

Regards,
Vijay.

3

Hi @Vijay_Kumar_C,
Yes two emails.
I want to send the invoice numbers in the email with to as the requestor email id and from customer email id both the invoices numbers should be sent in the same mail.

Thanks

4

Hey @Rishi_Mukherjee

First get unique value from Customer email column. after that with each unique value filter the main table. Follow below steps

  1. Use assign activity and use below code to get unique values from Customer email.
    DT_UniqueData = DT_Main.DefaultView.ToTable(true, “Customer email”)
    you will get a datatable with all unique values.

  2. After that use for each loop on DT_UniqueData and Filter DT_Main to get specific customer data.
    Use filter Data table activity.

Regards,
Vijay.

5

Hi @Vijay_Kumar_C,

I will try it out and let you know.

Thanks

6

Hi @Vijay_Kumar_C,

Please can you tell me how to filter out the data.

Thank.

7

Hi @Vijay_Kumar_C

I have done it like this
image

image

but it isn’t working out when I write the output into an excel it does not show any value.

Thanks

9

Hi @ArunVelaayudhanG,

Could you please help me out with this issue.

Thanks

10

Hey @Rishi_Mukherjee

please send me sample data with detailed requirement. i will create a flow for you and send it.

Regards,
Vijay.

11

Hi @Vijay_Kumar_C

I have attached an excel sheet .So,what I want is that there should two mails that needs to be send one to rishi@abc.com with the invoice numbers and other to rishi2@abc.com with all the invoice numbers from mail id arabinda@abc.com.

InvoiceDetails3.xlsx (8.7 KB)

The invoice numbers will be searched in SAP and an attachment will also be attached to these mails.