Mail Merge Recipient Window

[Sharon]

After I select the select data source dialog source and
then open the Mail Merge recipient window opens, I want
that window to open with certain defaults. For example,
when the Mail merge receipient window opens, I want the
window to open with "Clear All" function selected. I also
want the "find" window to automatically open and the
default to be "this field" selected with a specific field
default everytime I open the mail merge recipient window.
Is this possible?

 

[Cindy M -WordMVP-]

Hi Sharon,

After I select the select data source dialog source and
then open the Mail Merge recipient window opens, I want
that window to open with certain defaults. For example,
when the Mail merge receipient window opens, I want the
window to open with "Clear All" function selected. I also
want the "find" window to automatically open and the
default to be "this field" selected with a specific field
default everytime I open the mail merge recipient window.

Is this possible?

There's really no way at all to preset or change the
defaults
with which this dialog box opens, I'm afraid. But it would
be
possible to clear all the records before opening the dialog
box:

Sub MergeRecipientsDlg()
Dim dlg As Word.Dialog

Set dlg = Dialogs(wdDialogMailMergeRecipients)
With ActiveDocument.MailMerge.DataSource
.SetAllIncludedFlags False
End With
dlg.Show
End Sub

For displaying the "Find" box with a specific field
selected,
you can try the following, substituting the field name for
City:

Sub MergeFindDlg()
Dim dlg As Word.Dialog

Set dlg = Dialogs(wdDialogMailMergeFindRecord)
SendKeys "%(d)City{Enter}"
With dlg
.Show
End With
End Sub
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Sharon]

Cindy, the first macro opened the Dialog Window, but did
not clear all of the selections? I typed the macro
exactly as you did.

 

[Sharon]

The second macro opens a find box with a specific field,
but is that to find in the document, or in the Dialog Mail
Merge Recipient List?

 

[Cindy M -WordMVP-]

Hi Sharon,

Cindy, the first macro opened the Dialog Window, but did
not clear all of the selections? I typed the macro
exactly as you did.

Which version of Word do you have? It works here...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Cindy M -WordMVP-]

Hi Sharon,

The second macro opens a find box with a specific field,
but is that to find in the document, or in the Dialog Mail
Merge Recipient List?

In the document. There's no way to control finding records in
the dialog box.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail