I have a fairly complex problem that requires a simple solution. I have a worksheet with many records in approximately 100 columns. I also have a Word template with many bookmarks. I would like to link the bookmark entries to cells in the excel file so that when the file is updated so are the entries in the Word file. I can figure out how to do this manually but no with VBA.
Also, since there are several records I need to create a document from the template for each of the records. All of these need to put on a different page in a continuous Word document.
Any and all help would be greatly appreciated!!!
Bookmarks