SQL statement in mail merge document

[Rich W.]

When I bring up a mail merge doc (mm), I can view the SQL statement. Then I
dismiss the dialog box and continue.

But, later, how can I re-view the sql statement? (Currently, I open the
docuiment in "Recover Text" mode - that's an ugly way to do it.)

Thanks for any info . . .

Rich

 

[Peter Jamieson]

There isn't a really simple way (except perhaps close the document and
re-open it so you see the message again).

If you start the Word VB editor you can see any SQL by entering the
following in the immediate panel:

print activedocument.mailmerge.datasource.querystring

(You can show the immediate panel using ctrl-G once you are in the VB
Editor).

 

[Mrs Dumm]

Rich,
On a related note, if you want to CHANGE the SQL statement that is currently
attached to the merge form, you can use the "Open Data Source" button on the
Mail Merge toolbar and that seems to remove any previous filtering that was
in place. I can then refilter it as I choose using the "MailMerge
Recipients" button. I find if I open the "MailMerge Recipients" dialog, I
can't go "back" in the filtering that is already in place (that SQL
statement).

Alicia

 

[Rich W.]

Thank you very much; the vba code is a good idea.

Rich