>Thanks Borislav! That works great. One little issue is a prompt that comes up "Select Table", showing Sheet1$ with a checkbox "first row of data contains column header" which is checked by default.
>
>How would I control this to simply select "OK"?
>
>Gold stars are on their way to you!
>
>Thanks,
>Martha
Try:
oWord.ActiveDocument.MailMerge.OpenDataSource(m.dir+"data\labels.xls",,.f.,.f.,,,,,,,,,"SELECT * FROM [Sheet1$]")
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
