How to send multiple PDFs in separate emails based on ID

[Keisi]

I have an excel file, with each row containing specific data based on ID number. I want to extract for each row, a separate PDF file based on the ID number, and send each PDF to the email corresponding to that ID.

[atcodedog05]

Hi @Keisi 

Use the method in this post 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Save-Output-Data-as-Dynamic-File-Name-...

Step5: pass the To field from the column

Hope this helps : )

[Keisi]

Hi @atcodedog05 

Thanks a lot for your prompt response.

I've tried your solution and it works but it generates files in Excel, I need to send attachments by email only in PDF format. Do you have any idea how to convert each of them in PDF and send the PDFs via email? 

[atcodedog05]

Hi @Keisi 

Changes you need to do is use reporting tools instead refer the below workflow.

Hope this helps : )

[Keisi]

Hi @atcodedog05 

It generated 3 different emails according the excel file, but the PDF includes all the information found on the table while I would need each PDF to contain only the row corresponding to that email address. (So 1 row has 1 unique email address and I want a PDF that contains only that one row)
Can it be done? 

Thank you in advance, you already were really helpful.

[atcodedog05]

Hi @Keisi 

Create filename unique to each group like below and attach these. Currently this workflow doesn't create 2 files for each group.

Hope this helps : )