I have created Word templates that have the data source attached to a specific database via ODBC. When executing VB code for merging I need to be able to change the MailMerge.DataSource and .MailMerge.DataSource.QueryString if the default database is not found.

Any ideas on doing this on the fly?