Selecting the datasource is unavoidable if you want to use the same mailmerge document with different datasources.



Might I suggest a different approach: configure the Word document to use a single datasource and simply copy & rename the Excel workbooks accordingly.

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

I'm not quite following what you mean?? However, can I have the code choose data from the current workbook instead of choosing the data source? This way it would merge with the excel book that contains the updated information instead of the template that is used?

What you currently helped me out with works, but I need it as simplistic as can be. The people using this would not understand how to choose data and then the list. I was trying to get it all under one click of a button, but maybe I'm trying to do something not possible. Thanks