Access2003/Word2003 Mail Merge

[KenReay]

I am attmpting to automate Word Mail merge from Access, using code like

set wobj = GetObject(,"Word.Application")
set oDoc = GetObject(strLetterName,"Word.Document")

With oDoc
.MailMerge.OpenDataSource
Name:=Db.Name,
LinkToSource:=True,
Connection:="QUERY qMailMergeClient",
SQLStatement:="SELECT * FROM qMailMergeClient"

..etc

Anyone done this successfully and willing to discuss?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[RoyVidar]

I think you should be able to get/create an instance of Word with with your merge document using just:

[tt]set oDoc = GetObject(strLetterName)
' then
set wobj = odoc.parent ' if you need the parent object[/tt]

I think one of the challenges with the above, is that it may open an extra instance of Access (the query). So last time I had to do some mailmerge, I had a look at pseale's faq faq181-5088, which circumvents some of that hassle.

Roy-Vidar

 

[KenReay]

Thanks Roy, I am reading that right now will let you know how I get on

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK