Excel - Create PDF Files from a Spreadsheet - VBA Macro Mail Merge Tutorial

Learn how to create many PDF files from a template in Microsoft Excel (similar to a mail merge). In this tutorial we'll create a Macro (VBA code) that will take our spreadsheet data and convert it to separate PDF files in a folder.

#excel #pdf #vba

[thomassunil]

the best excel teacher i found after a long time

[oscarw]

Super useful! I use this code to create large number of personal reports for different users of one of our farm management programmes from an excel file. I used to do this via MailMerge, but wanted to create a version that allows for inclusion of charts that display the user's performance relative to the the larger population or other benchmark values. Getting charts into MailMerge is not impossible, but has severe limitations on the type of charts and the number of series in any given chart (only a single series is possible to my knowledge). Having a couple of charts in the Template and the Active sheet works a treat as long as automatic calculation is switched on. Thank you so much, discovering this video really made my day :)

[juliamt]

Thank you so much for this great tutorial! I am trying to apply this to a pivot table to generate a purchase order by customer (each customer has at least three purchased itens) on individual PDFs. Printing it separately is not an issue since I can set the customer filed on the pivot table as a page break. The challenge is generating and saving the pds. Looking forward to hearing from you on this :)

[FTIMAK]

WOW, it 's awesome~ I look forward the Google Spreadsheets version

[zaccoza]

Great work. Do you have a solution for google sheets too?

[MichaelGangler-ou]

Great code! super helpful... Was wondering how I could modify it to have all of the pdfs into one doc instead of separate ones. I am thinking that I need to move the 'next r' location?

[JoeSalmi]

This is AWESOME... I love your videos... I do have one question for this one though. If we were to add more customers to that list and click create PDF would it overwrite all the existing data or continue on with just he new data? Maybe add a check to see if file already exists?

[abdullahquhtani]

Excellent but you forgot to disable screen updating to stop annoying blinking of the screen specially when the list is long. One more thing, you could take this project one step further by creating templates word document and use them. Thank you

[YourOnlineMentor]

can you tell me.. how can we create a password protected pdf with different passwords.. like the name of pdf.. thank you

[Drivadk]

Thanks for the video. When i'm running through the code step by step using F8 (as shown around the 21 minute mark), the code isn't making any changes to my document. I've triple checked the code and it matches what's in the video perfectly, down to the last comma.
Is there any way to troubleshoot this?

[Animeisthebest]

Does this work if the cell value is in images?

[shrafidahedruce]

thanks, its really help, but how / what code to add if we want to read the next column, in this example here, we replace in A column only..(active sheet)

[mayurmarathe]

hi nice video, just wanted to check one thing can we disable the right click or editing the pdf file created, i just want user should not able to edit the pdf file if any pointers please help

[philipdesposito]

Fantastic work, thank you for taking the time to do the video. I'm having a problem with it. For my original data set it works fine. I essentially added more to the list and it stops at the original number and gives me a file not saved error. When I hit debug, it said the issue is in the activetab export section. Would you be willing to help me with this please?

[monishamoni]

Hi sir
Thank you so much & it worked well. But it would be of great help if we have code to directly send an email attaching those pdfs via outlook. Please would you mind updating that

[ashutoshvirtues]

Hi, Request to upload VBA code here in the Comments.thanks

[giancarloschafloqueguzman]

Excellent tutorial 👏👏👏
If possible generate a Word document for a template un Word 🙏🙏

[sugiartosugiarto]

how if we want to add chart, graph radar on that code bro. ?

[sanskrutiagrawal]

Why are curly brackets appearing in the pdf along with the cell value?

[chintanpandya]

What if on same I'd we are having multiple accounts and we want account balance details for all accounts in same pdf