S
S Taylor
I am running MSWord VBA code from within Access VBA that merges a Word mail
merge document to the printer, using data in Access.
In Office 97 it worked fine, but in Word 2003 a new message comes up in Word
when it tries to import data. The message is :
**********************
Opening this document will run the following SQL command:
SELECT * FROM 'Tbl.' WHERE 'Fld.' = 1
Data from your database will be place in the document. Do you want to
continue?
**********************
(Tbl. & Fld. are just random replacements that I have entered)
I want to return YES to this prompt and run the SQL command, but VBA just
seems to bypass it, and doesn't run it! Does anyone know how I respond to
this prompt or get round my dilemma?
Thanking you in anticipation.
Regards,
S Taylor
merge document to the printer, using data in Access.
In Office 97 it worked fine, but in Word 2003 a new message comes up in Word
when it tries to import data. The message is :
**********************
Opening this document will run the following SQL command:
SELECT * FROM 'Tbl.' WHERE 'Fld.' = 1
Data from your database will be place in the document. Do you want to
continue?
**********************
(Tbl. & Fld. are just random replacements that I have entered)
I want to return YES to this prompt and run the SQL command, but VBA just
seems to bypass it, and doesn't run it! Does anyone know how I respond to
this prompt or get round my dilemma?
Thanking you in anticipation.
Regards,
S Taylor