Using an Excel Workbook to auto fill data in an Adobe PDF Fillable RRS feed

  • Question

  • How is it possible to move data from an Excel Workbook to a PDF Fillable form using an Command Button? I have used a product similar to this before but cannot figure it out myself. Could someone please help me out with this?

    Long story short is that I have several lines of data across a workbook that I need the transferred to a PDF fillable for each line.

    What I would like to do is add a command button to the excel sheet that will generate a prefilled adobe pdf document that I have created.  All excel column names correspond to fillable blocks in the PDF. 

    I do not know how to get excel to push the information to the PDF document though.

    Monday, December 19, 2016 5:24 PM

All replies

  • Hi jrb,

    For writing PDF Forms From Excel, I suggest you refer the link below:

    # Read And Write PDF Forms From Excel (VBA)

    Best Regards,


    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Tuesday, December 20, 2016 7:39 AM
  • Hello jrb_1504,

    maybe our software could do what you want.

    With PDF Mail Merger you can automatically fill an existing PDF form with data from an Excel file (also known as mail merge). Each line in the Excel file generates a new PDF document, filled with the data from the corresponding line.

    It is very easy to use and we also offer a free plan!



    Wednesday, July 22, 2020 3:39 PM
  • Hi,

    I think you should see this video and if u have to do the task similar to this video then i will make for you.

    or search in youtube "How to fill excel data in PAN Form and print or save pdf automatically"

    Saturday, September 5, 2020 3:51 AM