+ Reply to Thread
Results 1 to 3 of 3

How to Access MailMerge Edit Recipient Menu in VBA

  1. #1
    Registered User
    Join Date
    10-02-2011
    Location
    Los Angeles, USA
    MS-Off Ver
    2010 Home Version (doesn't include Access and Outlook )
    Posts
    22

    How to Access MailMerge Edit Recipient Menu in VBA

    I cannot get the Mailings| Edit Recipients List menu to show using VBA. When I record a macro and click on the Edit Recipients List icon, the menu/deselect table pops up, but the macro recorder records no commands.

    I have a MailMerge macro where I set the data source to an excel workbook using the ActiveDocument.MailMerge.OpenDataSource command. I further refine the data by setting the SQL statement with the SQLStatement command.

    I would then like to be prompted with the Mail Merge Recipients Menu to manually deselect certain recipients.

    As it is, I have one macro that sets the data source and ends. I then manually click on the Edit Recipients List icon to invoke the recipient table to deselect certain data. (It is this table/menu which I wish to invoke with VBA.) I then run another macro which completes the merge.

    If I could cause my macro to display the Edit Recipients Menu, I could use only one macro to do this task which would be more streamlined and elegant.

    Thanks.
    Last edited by Dirigo; 11-12-2011 at 06:24 PM.

  2. #2
    Registered User
    Join Date
    01-11-2013
    Location
    Oostende, Belgium
    MS-Off Ver
    Office 2010 Pro
    Posts
    2

    Re: How to Access MailMerge Edit Recipient Menu in VBA

    Hi,

    Did you get this issue resolved?
    I've kind of ran into the same problem.

    Thanks in advance.

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    Oostende, Belgium
    MS-Off Ver
    Office 2010 Pro
    Posts
    2

    Re: How to Access MailMerge Edit Recipient Menu in VBA

    Never mind, I found it.
    The command to use is this

    Application.Dialogs(wdDialogMailMergeRecipients).Show

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1