Opening mail merge document from access

  • Thread starter Thread starter lucifer
  • Start date Start date
L

lucifer

Hi. I am attempting to open a mail merge document from access. I thought
that I had it working but when the document opens the mail merge facility is
not available and I have to re-connect to the data I want to merge with to
get any updated data. But when I open the document straight from the disc it
links to the source and has the merge facility available showing any updated
data. I have linked to the document using the following code:

Dim oApp As Object

Set oApp = CreateObject("Word.Application")
oApp.Visible = True
oApp.Documents.Open "I:\College\Foundation Degree ICT Year 2\Work
Experience\Word\Member_Labels.doc"

Like I said this opens the document but not with the merge facility. Can
anybody help please?

Thanks
 
Back
Top