Access 2003 mail merge fails to recognise a mail merge document.

[ColinD]

I am trying to merge a single record in an Access table into a Word document.
I have set the data source in the Word document, and when I open it, it
correctly displays the record from Access.

However, I would like to be able to open the document programmatically from
within Access, with this code:

Set wrdDoc = wrdApp.Documents.Open("doc name", , True)
wrdDoc.MailMerge.Execute

But the Execute property generates the error:
This method or property is not available because the document is not a mail
merge main document.
The document opens but does not display the right record.

Any help would be appreciated.
Many thanks
Colin Dimond

 

[Albert D. Kallal]

I have a nice working sample that does a merge of the current record to
word.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the follwoing page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try.