By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,995 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Word mail merge from Access

P: n/a
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

(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.

S Taylor
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Found this in another group

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.