Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
SQL statement in mail merge document
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
SQL statement in mail merge document
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). -- Peter Jamieson http://tips.pjmsn.me.uk "Rich W." wrote in message news 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
SQL statement in mail merge document
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 "Peter Jamieson" wrote: 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). -- Peter Jamieson http://tips.pjmsn.me.uk "Rich W." wrote in message news 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
SQL statement in mail merge document
Thank you very much; the vba code is a good idea. Rich "Peter Jamieson" wrote: 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). -- Peter Jamieson http://tips.pjmsn.me.uk "Rich W." wrote in message news 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge - If statement | Mailmerge | |||
mail merge if statement | Mailmerge | |||
mail merge IF statement question | Mailmerge | |||
mail merge and sql statement | Mailmerge | |||
Mail Merge - Next Record If Statement | Mailmerge |