Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2007

Tip: Looking for answers? Try searching our database.

Automatically show recipient list on Word Doc open.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dougie Still Going Crazy - 29 Jun 2007 11:50 GMT
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.
Graham Mayor - 29 Jun 2007 13:55 GMT
Do you mean like

Dialogs(wdDialogMailMergeRecipients).Show

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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
[quoted text clipped - 7 lines]
> hence the need to have the list show up upon opening the document.
> Hope someone can help.  Cheers.
Dougie Still Going Crazy - 29 Jun 2007 22:20 GMT
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?

> Do you mean like
>
[quoted text clipped - 11 lines]
> > hence the need to have the list show up upon opening the document.
> > Hope someone can help.  Cheers.
Peter Jamieson - 29 Jun 2007 23:29 GMT
Before you display the form,

ActiveDocument.MailMerge.DataSource.SetAllIncludedFlags Included:=False

Peter Jamieson
> Thanks Graham, I knew it would be easy once I found out the correct code.
>
[quoted text clipped - 15 lines]
>> > hence the need to have the list show up upon opening the document.
>> > Hope someone can help.  Cheers.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.