Opening different excel work books on SQL command

J

jdd

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

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
 
Top