Automated Mail Merge without confirming data source
Posted on 2006-10-31
I have a mail merge that is automatically generated from Access which works fine. If possible though, I'd like to get rid of the "confirm datasource" message that pops up. I know which datasource to pick, but my users won't and I'm afraid this will just confuse them. Here's my merge code, shamelessly plagarized from Microsoft:
Dim objWord As Word.Document
Set objWord = GetObject("T:\DATABASE\Client Case Blurbs.doc", "Word.Document")
' Make Word visible.
objWord.Application.Visible = True
' Set the mail merge data source
objWord.MailMerge.OpenDataSource Name:="T:\DATABASE\Clients.mdb", _
Connection:="TABLE ExportBlurbsTable", _
SQLStatement:="SELECT * FROM [ExportBlurbsTable]"
' Execute the mail merge.