Send different PDF files by mail to different people

Help Activities
,
1

I have to send by mail to 450 people different, 450 different pdfs to each of them. How do I do it ?

2

@Maria_Alejandra_Rojas_Riv

How do you know which pdf to be sent to which email?

Do you have any excel sheet maintained or something?

If ao you can loop theough excel and inside loop send email

Cheers

3

@Maria_Alejandra_Rojas_Riv,

Welcome to the UiPath Community :tada:

First thing you should have a clear mapping of PDF file path and recipient email id.

Once ready just read the excel file using read range into DataTable, then iterate using For Each row in Datatable activity.

Inside it, use Send Outlook Mail message activity to send the emails.

Thanks,
Ashok :slight_smile:

4

@Maria_Alejandra_Rojas_Riv Welcome to you UiPath Forum Community,

So you have to send 450 mail then you need to create the master file where you keep all email and source file that need to be sent for each user.

then you look at each line in Excel, send the mail, and update the status pass and fail.

“If you have to create the dynamic PDF using the same template” then you need to add the other information to the Excel file generate the PDF and store it in specific location and keep this file path in excel

once its done the you send the mail each user.

@Maria_Alejandra_Rojas_Riv I hope this solve your issue.