I have several hundred forms to generate based on information stored in Excel. The data for each form is per row and moves across multiple columns. I was wondering if there is a macro to export the information from Excel into Word and then save each file as the ID of each resource, column B. The goal would be once each set is completed for a group to just run the macro once and have it save each form individually. If it is also possible it would be appreciated to have it save the Word file as a PDF. Attached is a small sample of how the data is in Excel and just an idea of the simple layout in Word. Thanks and I appreciate any help.
Bookmarks