Mail Merge and .PDF Save

[Jarzzz (Kyle)]

Hey All!

I have a process that will be running a mail merge. Rather than “Print Documents…” I will need to save each individually as a PDF. I know how to do this manually, step through each recipient and “Save As… PDF”. However this is very time consuming even for an RPA process.

Has anyone ever automated a process like this?

[bcorrea (Bruno Correa)]

you can select multiple at the same time… then if print works, better, but can also save as text and after merge.

[anmolk171 (Anmol Kumar)]

@Jarzzz - I have done the same thing but it is lengthy.

1. Save the mails in .eml format or .oft in some folder.
2. then iterate through very mail and perform the action like save as pdf using bot for all the files and store in another folder.
3. Then merge all the pdf using JoinPDF activity. Here is the link.
   https://docs.uipath.com/activities/docs/join-pdf-files

Hope it will help you.

Best!!
Anmol

[Palaniyappan]

HI
hope this would help you

How to convert Outlook mail to pdf file

Make use of Package shown below [image] Try with this XAML file which saves emails to “D:\savemails”(create folder as required) and it even creates respective html file. Check and let me know if this helps. saveEmailPDF.xaml (6.1 KB)

CHeers @Jarzzz

[Jarzzz (Kyle)]

Thank you for the comments! Not what I’m looking for just yet…

@bcorrea - I haven’t tried this but am a bit hesitant as the Mail Merge Documents i am dealing iwht are approved by mangers and legal. Any alteration would require a lot of red tape.

@anmolk171 @Palaniyappan - I’m attempting to create PDF from a Microsoft Word Document Template with Mail Merge Fields using an Excel Document with said Mail Merge Fields as a Recipient List.

[Jarzzz (Kyle)]

At the moment there are some new Scope Items being added and this portion of the Mail Merge may be changed.

Thank you @bcorrea @Palaniyappan @anmolk171 for your input!