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
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Found this in another group http://support.microsoft.com?kbid=825765

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.