Individual mail with different file

I want to mail an individual. I have ten unique names, ten unique PDF files, and ten email addresses. He needs to send emails with the attachment of the appropriate PDF file to each email address.

  1. Is it possible to see PDFs using a name in a Google search and then attach them to emails?
  2. i want to know which Activity we should use what all are the steps will be there

It will be a great help :slight_smile:
Thank you

@toufikmujawar
Read Data:

Create an Excel or CSV file with two columns: one for names and another for corresponding email addresses.
Use the “Read Range” activity to read the data from the file into a DataTable.
Loop Through Data:

Use a “For Each Row” activity to iterate through each row in the DataTable.
Compose Email:

Inside the loop, use the “Assign” activity to compose the email body, incorporating the name from the current row.
Use the “Assign” activity to set the attachment path based on the name.
Send Email:

Use the “Send SMTP Mail Message” activity to send the email. Input the email address from the current row as the recipient, and set the attachment path.

@toufikmujawar

i think you can make unique names to sort in ascending order

and pdf file ,Email Address also ascending order

so that you can use for each/while to send the mails

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.