Fill out PDF form with Excel Data

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!



​

Please Login or Register  to view this content.

Please read the Forum Rules at the top and react to #3 For all other sides you posted on.

See 2nd post here: www .ozgrid. com/forum/index.php?thread/1227881-fill-pdf-form-from-excel-list/

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

Please Login or Register  to view this content.

Will you please post an example workbook with fake data? I want to use the code but i dont know what the code is referring to. I am also a beginner it would be very helpful!