Opening different excel work books on SQL command

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jdd - 28 Jul 2008 18:26 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 29 Jul 2008 02:30 GMT

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

Signature

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

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

Reply to this Message