Merge excel data into a pdf document with form fields

Posted on 2008-11-20
Last Modified: 2012-08-13
Hi There,

I was wondering if anyone can help with this we need to merge excel data into a pdf a bit like you do a mail merge with a word document. We have limited software options as this is for a client who are very restrictive on downloading products so we must do this with Excel and Adobe Acrobat Standard.

So just to reconfirm the excel has many rows and the pdf document has a few form fields and we need to bring that excel data in to the pdf document into these form fields and do the same technique as a word mail merge to create many doc's...hope that makes sense.


Question by:keyparker
    LVL 13

    Accepted Solution

    I use a program called activepdf ( we use the more robust version but I think the lite version will do what you want.

    It allows you to manipulate via an activeX control a PDF document and save the information that you "fill" into fields on the document, it works great.

    I don't think your going to find a freebie when it comes to modifying and saving a PDF document.


    Author Comment

    Hi NG

    Thanks for that i think i am going to resign that fact this is the best way to go with this.

    I will award the points...and especialy as this helps with something else in the future so cheers.



    Author Closing Comment

    Thanks for the help
    LVL 13

    Expert Comment

    Glad it can be of use - its a nice control and has done well for us. There are probably other solutions but it was pain free to implement for us.

    Good luck!


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now