Paul,



Thanks for your insight. I'm going to give your code a look once I've finished touching up my current application. The thread can be closed.

-Rich

It should be apparent from the code I posted, that this is also a simple way to address the issue you raised in: https://www.msofficeforums.com/excel...-word-doc.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Paul, part of the reason I'm using Excel is that a large amount of the data entered in Excel is manipulated in formulas to give me different results for the mail merge. I'm not sure I can do my process without Excel's functionality. (ie. user enters dates, dates are then used to calculate total days in between based on a work days calendar that I've created in the Excel workbook.)

The workbook you attached didn't give any indication of that. Regardless, a macro along the lines of the one I posted would do the job just fine, without the need for a mailmerge.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]