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

Need Help with Mailmerge to Word 2003

P: n/a
Some of our users have converted to Office 2003. Our Access app is in
2000. they run it in Access 2003 with Access 2000 as the default file

When doing a merge from the partial code segment below, we had rec'd
the :
"Opening this will run the following SQL Command" message. We were
able to suppress that message with registry changes and code contained
in MSKB 82765.

However we are still getting the :
Select data source dialog box which asks the user to select the

How can we suppress that dialog box ?


Set objWord = GetObject(strFileLocation, "Word.Document")
'turn off alerts
objWord.Application.DisplayAlerts = wdAlertsNone
' Make Word visible.
objWord.Application.Visible = True
' Set the mail merge data source as the OLF Front End database.
objWord.MailMerge.OpenDataSource _
Name:="C:\my Documents\OurLady2000.mdb", _
LinkToSource:=True, _
' Execute the mail merge.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.