Fill PDF form from Excel List

  • This is my first time using VBA and I am trying to use it to fill out 1,000 forms from an Excel spreadsheet. I watched a video on youtube and was able to fill the form out with this code but is there a way to modify this to pull from my excel spreadsheet?

    I need

    Business = Column A

    Address = Column B

    Zipcode = Column C

    FEIN = Column D

    I need it to fill out one form for each record then save that PDF file as the Business name (Field: Business)

    I really hope someone is able to help! We are a small development agency that is trying to distribute a grants to small businesses that have been effected by COVID and we have little man power. Thank you in advance!

  • Here is the solution I came up with based on researching and trial and error:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!