Hello,
I'm working on a project where I have an excel sheet that has a list of people with information about each person in columns and I need to put each person's data into a specific location on multiple word documents, each document unique to the person. So basically one row is one person and all the columns specific to that person get transferred to a word doc, the doc would get saved, a new one would be opened and the next row in the excel doc would get copied over, etc.. I'm using bookmarks on the word doc as references in my vba doc right now. So far I've gotten one row's worth of information to transfer to a word doc but I don't know how to make it save, open a new one then repeat on the second row. Seems like I would need a loop of some sort. Any help would be appreciated.
My current docs are attached, the word doc I actually made into a template, which I though might help with the saving multiple copies, but the forum won't let me attached a doc template.
Bookmarks