I need to make a macro that creates a Word doc. and corresponds with an Excel spreadsheet. I have a typed out proposal for my work. I have decided to use individual identifiers like "Project_Title1" or "Contact_Name," or things like that. Then I have connected those to be replaced with cells from my excel spreadsheet. This is all working out well.
My problem is that I need to be able to make a list. Each proposal may have a different number of things that need to be listed. I have tried to do the same thing as above with the list, but it ends up leaving a huge gap in the middle of my word doc.
Here is a short example of what I have so far:
Moderators note: code tags added for you - this timePlease Login or Register to view this content.
Bookmarks