Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Automatically show recipient list on Word Doc open.
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Automatically show recipient list on Word Doc open.
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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Automatically show recipient list on Word Doc open.
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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Automatically show recipient list on Word Doc open.
Before you display the form,
ActiveDocument.MailMerge.DataSource.SetAllIncluded Flags Included:=False Peter Jamieson "Dougie Still Going Crazy" wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change a recipient list in Word mail merge? It won't let me do. | Mailmerge | |||
How do I print a recipient list from a mail merge list in Word? | Mailmerge | |||
Change default details that show in Open list of files | Microsoft Word Help | |||
Word Mail Merge Recipient List | Mailmerge | |||
How can I print a recipient list created in Word? | Mailmerge |