Opening different excel work books on SQL command

[jdd]

I have 4 excel work books i would like to choose from while opening the WORD
document mail merge. How?

 

[Doug Robbins - Word MVP]

Change the document to a Normal Word Document then save it as a template in
which you create a macro named AutoNew that contains the following code:

Dialogs(wdDialogMailMergeOpenDataSource).Show

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP