Ok, so this is my first time posting to any forum (ever) so I apologize in advance for any breaches of etiquette.

Here is my issue: I work in contracting, and I've built a spreadsheet for my office that minimizes data entry and allows for (relatively) easy form letter creation using mail merge. The problem is that I have to maintain five separate Word files, and it can take quite a while for the merge to do its thing. So now I'm building a mother of a workbook that will act as a sort of 'wizard' for my work section, combining almost all of our data processing functions into one self-contained Excel product. For the most part the project is coming along great, but the part that is really holding me up is replicating the mail merge.

See, what I've done is embedded the Word docs into their own individual worksheets (say Sheet1 through Sheet5), and the user data that is input through various userforms all ends up on one big 'Review' worksheet. What I can't figure out is how to code it so that the data that from the Review worksheet is transferred into 'merge fields' in the embedded Word docs so that the process remains automatic. My driving goal is to for the project to remain completely self-contained in one Excel workbook. Sorry for the novel, and thanks in advance for any advice!