A macro such as the following would probably be enough in this case as long
as you havenot entered so many criteria/sort options that the querystring
exceeds around 255 characters:
It works in Word 2003 anyway. I don't think there is a simpler way.
Sub requery()
With ActiveDocument.MailMerge
.OpenDataSource _
Name:=.DataSource.Name, _
Connection:=.DataSource.ConnectString, _
SQLStatement:=.DataSource.QueryString, _
subtype:=wdMergeSubTypeWord2000
End With
End Sub
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Dave C" <DaveC[ at ]discussions.microsoft.com> wrote in message
news:6EB1E801-218D-466A-ABE6-696CF1B087AE[ at ]microsoft.com...
[Quoted Text] >I have a Word mail merge document that retrieves its data from an Access
> parameter query where the user is prompted to enter the unique employee
> number. When opening the mail merge document the dialog box is displayed
> for
> the user to enter the employee number and the respective merge fields are
> populated.
>
> Now my question ... after printing the first merged document (employment
> contract) I need to be able to redisplay the query dialog box in order for
> the user to enter a new employee number in order to refresh the query and
> populate the merge fields with the new employee data.
>
> Is there a predefined menu/toolbar option to do this, if not, what code
> would I need to place in a command button to achieve this.
>
> Thanks in advance for any assistance and guidance.
>
> Dave
>
>
|