Forum Discussion

glukemeyer's avatar
glukemeyer
Copper Contributor
Feb 18, 2021

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...
Excel
Macros and VBA
NikolinoDE's avatar
NikolinoDE
Gold 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's avatar
glukemeyer
Copper Contributor
Feb 18, 2021

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 Karlsson's avatar
    Niklas Karlsson
    Copper Contributor
    Sep 17, 2022

    glukemeyer 

    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/ 

Resources