Opening mail merge document from access

[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

 

[Tom Wickerath]

Try Access MVP Albert Kallal's "Super Easy Word Merge". You can find a copy
on this page:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________