What is the best way to take an excel workbook with customer information in various places in it and dump that information into a pre-made contract template? I could write a macro, but it would not know which template to use, only a user would know that based on project parameters. I say that, there are only a couple different kinds of projects and I could create a list in excel to select that kind, I just don't know how the macro would then be able to determine with that preset parameter that it would link back to a certain word doc.
Bookmarks