Automatically show recipient list on Word Doc open.

  • Thread starter Dougie Still Going Crazy
  • Start date
D

Dougie Still Going Crazy

Hi all, I am setting up a couple of Word documents in 2003 where I will be
using Access2003 for the merge information. The required recipients will be
a different selection each time so I am trying to write a macro that will
automatically display the list of recipients when the document is opened and
automatically clear the check boxes so that the user can select those that he
requires. I've searched through help but I cannot find the VBA code that I
need. I can get it so that the MailMerge Toolbar automatically opens but
some of my users are not that computer literate. I need to hold their hands,
hence the need to have the list show up upon opening the document. Hope
someone can help. Cheers.
 
G

Graham Mayor

Do you mean like

Dialogs(wdDialogMailMergeRecipients).Show

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
D

Dougie Still Going Crazy

Thanks Graham, I knew it would be easy once I found out the correct code.

Just one more quick one, how do I clear all the check boxes?
 
P

Peter Jamieson

Before you display the form,

ActiveDocument.MailMerge.DataSource.SetAllIncludedFlags Included:=False

Peter Jamieson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top