Still can't get Word Mail Merge correct

[charle525]

I've been working on this mail merge for a while and can't get it right (Office XP). I want the document to merge from a query that is already in the database and then to be filtered to only the record that is showing on the form. The code I've found in other threads is all similar but doesn't quite work for me. Here is some of my code:

Dim objWord As Word.Document

Set objWord = GetObject("C:\COEWork\Letter_TBV.doc&quot
objWord.Application.Visible = True

objWord.MailMerge.OpenDataSource
CurrentProject.Path, , , , True, , , , , , , "QUERY
qryStudentMinor", "Select * from [qryStudentMinor]
WHERE [id]='" & Me!txtID & "'"

objWord.MailMerge.Destination = wdSendToNewDocument
objWord.MailMerge.Execute

I've used the actual DB path instead of CurrentProject.Path and that hasn't worked either. I've tried my word document with the data source already set to the DB and with it empty and just the merge fields in the body. When I press the form button, Word opens and I get a "Confirm data source" dialog box and I don't know why. Do I need to set up an actual ODBC data source? Do I need to change my code? The word document? Please help! Thanks.

 

[DougP]

I'm not up on the new fangeled procedures but this has worked since Office '97

Dim stAppName, macroname As String
macroname = "Printme"
stAppName = "C:\Microsoft Office97\Office\WINWORD.EXE c:\Mydoc.doc /Mmacroname"
Call Shell(stAppName, 1)

DougP, MCP

 

[charle525]

Thanks, but I'm not sure that will work. My code matches what multiple people have suggested but doesn't work. I still get this dialog to confirm data source when Word opens. I'm wondering if something is set wrong in the db, in Word, or if I need to create an ODBC DSN?