Mail Merge Recipient Window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharon - 02 Jun 2004 15:50 GMT

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?

Reply to this Message

Cindy M -WordMVP- - 03 Jun 2004 15:45 GMT

Hi Sharon,

> After I select the select data source dialog source and
> then open the Mail Merge recipient window opens, I want
[quoted text clipped - 4 lines]
> 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

:-)

Reply to this Message

Sharon - 04 Jun 2004 14:41 GMT

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

>-----Original Message-----
>Hi Sharon,
[quoted text clipped - 53 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 09 Jun 2004 16:09 GMT

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

:-)

Reply to this Message

Sharon - 04 Jun 2004 14:46 GMT

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?

>-----Original Message-----
>Hi Sharon,
[quoted text clipped - 53 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 09 Jun 2004 16:09 GMT

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 :-)

Reply to this Message