[Dave C]

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

[Peter Jamieson]

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" wrote in message
...
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