Tamar, et. al.,
I was finally able to find my Automation book and I had downloaded the SC files and got the merge via an Excel file into Word working with one exception, and that is when I hit the oDocument.MailMerge.OpenDataSource line in the Alt2CreateDataSource program, I'm forced to select a Table to complete the merge as shown in the attached image.
I've run the code you reference in this thread pretty much unchanged except to change the data source and the merge document that I had already created so that they match.
After receiving the dialog to select the range, I attempted to fix the above-described problem by trying to tell Word the Range|Table to use. The attached image has the value "TABLE ALLSRTMP" which is the name of the merge template without the extension. I've tried without the TABLE prefix and ALLSRTMP with and without a "$" suffix, all to no avail.
Any idea on how to force the selection of the Excel Table|Range to be used in merging into the Word document?
Thanks
Kevin
Kevin R. Hunt