Forum Discussion
glukemeyer
Feb 18, 2021Copper Contributor
Create Multiple Word/PDF Documents From Excel
Hey there- I'm trying to create multiple documents (preferably PDF but can be Word) based off an excel file and it's data. Essentially trying to create instructions for groups as they comple...
NikolinoDE
Feb 18, 2021Gold Contributor
sry topic totally messed up. Would you like to save from Excel to PDF? Simply go through file -> Export or save as PDF depending on the Excel version. Please ignore previous post if useful. cheers, Nikolino
glukemeyer
Feb 18, 2021Copper Contributor
Hi NikolinoDE -
I appreciate the reply, but the issue is that I need multiple documents from the data off the excel file. So unfortunately neither are what I'm looking for.
I have a template for the instructions I want to create and all the data, but trying to find an automated way to create them instead of having to manually Copy & Paste values for each.
Better way to describe could be that I want to mail merge but create separate documents to each line/group in the excel file. Currently, the only option I have is a mail merge which creates one document, with the different lines/groups on the next page of the same document.
- Niklas KarlssonSep 17, 2022Copper Contributor
I have found a solution for you. A tool where you input a Word file as template and an Excel file with the data. Out comes the many files you need! Good luck 🙂
Link to tool: https://www.mergeguru.com/