Refresh Merge Records

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

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 RemoveThis @discussions.microsoft.com> wrote in message
news:6EB1E801-218D-466A-ABE6-696CF1B087AE@microsoft.com...
>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
>
>