Controlling Word from Access

[48Highlander]

I am trying to execute a mail merge from access using a very complex query which is based on two previous queries. When I execute this mail merge manually from Word, I have to get access to this query via DDE as detailed in the following MS KB article:

http://support.microsoft.com/kb/320476/en-us

When the following code executes, I get a message that Word cannot find the query. Note that the document I reference already has a link to the query via DDE.

Public Function MergeIt()

    Dim odoc As Word.Document
    Dim objWord As Object
    Dim DataSource, Connection, CurrentPath As String
        
    CurrentPath = CurrPath

    Set objWord = CreateObject("Word.Application")
    objWord.Visible = True
    
    Set odoc = objWord.Documents.Add(CurrentPath & "\" _   Me.cboLetterSelect.Column(3))
    
    odoc.MailMerge.OpenDataSource Me.cboLetterSelect.Column(4)
    odoc.MailMerge.Execute
    'odoc.PrintOut

End Function

Has anyone got any ideas how I can get this to work? I am not familiar with connection methods such as OBDC but if that is what I have to learn, so be it.

Bill J

 

[Remou]

You might like to look at:
'Native' mailmerge reports - as painless as possible
faq181-5088
by PSeale

It is a different way of going about a mailmerge that may suit.