I have a small problem that I culd'nt resolve

The situation is like this:
I have about one hundred pay slips in Word doc. for the same amount of
employees. These files have Merged fields from the database. Now I tried to
select all word files and right click and then click on option Print. On
Opening every file one after other, the following message keeps popping up:


Opening this document will run the following SQL command:

SELECT *FROM `Table1`

Data from tour database will be placed in the document. Do you want to
continue?

Yes No

How can I disable this message so I can leave computer printing on late
hours, without having to monitor the prining my self.

ILIR ISTREFI wrote:
I have a small problem that I culd'nt resolve

The situation is like this:
I have about one hundred pay slips in Word doc. for the same amount of
employees. These files have Merged fields from the database. Now I tried to
select all word files and right click and then click on option Print. On
Opening every file one after other, the following message keeps popping up:


Opening this document will run the following SQL command:

SELECT *FROM `Table1`

Data from tour database will be placed in the document. Do you want to
continue?

Yes No

How can I disable this message so I can leave computer printing on late
hours, without having to monitor the prining my self.



Why not use the option 'merge to new document', which will give you the
hundred pay slips on separate pages in one document, and then print the
file? You can later either find the individual pay slip in the file if
you ever need to print a duplicate or, if you need to, run a separate
SQL query to retrieve the individual's payslip (or all his payslips)
from your database.

Steve

"Stephen Glynn" wrote in message
...
ILIR ISTREFI wrote:
I have a small problem that I culd'nt resolve

The situation is like this:
I have about one hundred pay slips in Word doc. for the same amount of
employees. These files have Merged fields from the database. Now I tried
to select all word files and right click and then click on option Print.
On Opening every file one after other, the following message keeps
popping up:


Opening this document will run the following SQL command:

SELECT *FROM `Table1`

Data from tour database will be placed in the document. Do you want to
continue?

Yes No

How can I disable this message so I can leave computer printing on late
hours, without having to monitor the prining my self.

Why not use the option 'merge to new document', which will give you the
hundred pay slips on separate pages in one document, and then print the
file? You can later either find the individual pay slip in the file if
you ever need to print a duplicate or, if you need to, run a separate SQL
query to retrieve the individual's payslip (or all his payslips) from your
database.

Steve



Thaks for replying but this solution does not resolve my problem.
The problem on this issue is that not all pay slips have same text which
text is not on the database but on the paticular word doc. Text varys on job
positions, grades and other data relevat to the paticular job positon. And I
have to use current pay slip forms, I am not allowed to change the design.
so the only way of using data from the database is merging fields to
multiple word doc. forms.

Ilir

You may find help in "Opening This Will Run the Following SQL Command"
Message When You Open a Word Document
http://support.microsoft.com/?kbid=825765

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"ILIR ISTREFI" wrote in message
...
I have a small problem that I culd'nt resolve

The situation is like this:
I have about one hundred pay slips in Word doc. for the same amount of
employees. These files have Merged fields from the database. Now I tried
to
select all word files and right click and then click on option Print. On
Opening every file one after other, the following message keeps popping
up:


Opening this document will run the following SQL command:

SELECT *FROM `Table1`

Data from tour database will be placed in the document. Do you want to
continue?

Yes No

How can I disable this message so I can leave computer printing on late
hours, without having to monitor the prining my self.