[Word 2003 & Excel 2003] Mailmerge multiple sources

[datapard]

I have been tasked with creating a macro that would give the user a list of excel file data sources to chose from for a mailmerge.

The object is to minimize the number of front end steps that appear when the document is opened as the end users are not that Word and Excel savy.

My problem is that I can not figure out how to code the macro that I will be putting in the document.

I know that the form I will be creating will be fairly simple with a drop-down list offering the file choices for the merge, I'm just not sure how to prevent the following two steps that I am concatenating in the form from appearing to the end users.





Suggestions with be happily attempted.


Updated spec:

I also have to have it set to looking for the files in the directory that the Word doc is in, as it can't be totally guaranteed the directory will be in My Documents (for example).
datapard