Automatically show recipient list on Word Doc open. Dougie Still Going Crazy 6/29/2007 10:50:02 AM 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.

Re: Automatically show recipient list on Word Doc open. "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 6/29/2007 12:55:15 PM Do you mean like Dialogs(wdDialogMailMergeRecipients).Show -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Dougie Still Going Crazy wrote: [Quoted Text] > 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.

Re: Automatically show recipient list on Word Doc open. Dougie Still Going Crazy 6/29/2007 9:20:00 PM 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? "Graham Mayor" wrote: [Quoted Text] > Do you mean like > > Dialogs(wdDialogMailMergeRecipients).Show > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > Dougie Still Going Crazy wrote: > > 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. > > >

Re: Automatically show recipient list on Word Doc open. "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/29/2007 10:29:05 PM Before you display the form, ActiveDocument.MailMerge.DataSource.SetAllIncludedFlags Included:=False Peter Jamieson "Dougie Still Going Crazy" <DougieStillGoingCrazy[ at ]discussions.microsoft.com> wrote in message news:CAFEC27B-BC48-4E30-B7AD-9FF6365D7746[ at ]microsoft.com... [Quoted Text] > 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? > > "Graham Mayor" wrote: > >> Do you mean like >> >> Dialogs(wdDialogMailMergeRecipients).Show >> >> -- >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> Graham Mayor - Word MVP >> >> My web site www.gmayor.com >> Word MVP web site http://word.mvps.org >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> >> Dougie Still Going Crazy wrote: >> > 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. >> >> >>