N
Newsgroups
I have an application that maintains info on continuing-education classes. I
have a startup form with various processing options, and would like to add
one that generates mailing list labels for all folks that attended a given
class. I have a form that lets me select the desired class ID, and then runs
a query to return the name & address info for the attendees. Now, I would
like to call Word where this recordset would be used to produce mailing list
labels. I can do this manually by using the Office Link wizard -- how can I
automate this process? I've got the Microsoft books 'Running Access 2000'
and 'Running Office 2000' but can't find the clues that I need. I have VB
experience, and think I need something like:
Dim wdobj As Object, wddoc As Object
Set wdobj = CreateObject("word.doc")
Set wddoc = wdobj.Application.Activate ?????
Any help greatly appreciated!
Jack
have a startup form with various processing options, and would like to add
one that generates mailing list labels for all folks that attended a given
class. I have a form that lets me select the desired class ID, and then runs
a query to return the name & address info for the attendees. Now, I would
like to call Word where this recordset would be used to produce mailing list
labels. I can do this manually by using the Office Link wizard -- how can I
automate this process? I've got the Microsoft books 'Running Access 2000'
and 'Running Office 2000' but can't find the clues that I need. I have VB
experience, and think I need something like:
Dim wdobj As Object, wddoc As Object
Set wdobj = CreateObject("word.doc")
Set wddoc = wdobj.Application.Activate ?????
Any help greatly appreciated!
Jack