How to send pdf to the respective emailid

I have list of pdf’s in a folder. and i need to send each pdf to a particular emailId.
for that i have created input file mention below

image

kindly help me how can i do this

thanks in advance

1 Like

Fine
hope these steps would helpyou resolve this
–use a excel application scope and pass the file path as input
–inside the scope use a read range activity and get the output with a varaible of type datatable named dt
–now next to that use FOR EACH ROW activity where pass the dt as input and
–inside the loop use a SEND OUTLOOK MAIL ACTIVITY where inthe TO mention as row(0).ToString and in the subject and body mention the string you want
–while in the ATTACH FILE property in the activity mention this as IN argument row(2).ToString

Cheers @asha_TN

  1. Read the excel and in result provide the datatable name
  2. Use For each row activity and inside it place SMTP activity in the To property give row(“Email”).ToString and in Attachment property give row(“FilePath”).ToString
  3. Save and Run

Let me know if any issues.

i am getting an error “A non recoverable error occurred during a database lookup” for Send SMTP mail message activity while running bot.

@Palaniyappan- i am getting an error “A non recoverable error occurred during a database lookup” for Send SMTP mail message activity while running bot.