export a query/mail merge To MS Word from Access In code

[Aaron]

Hi People,

Does anyone know how to start a mail merge with ms access to ms word?

At the moment i select the records i wish to merge with a query, get
the results, then select Office Links from the menu that goes through
a wizard to acomplish the merge.

I would like to create a Command button on a form that upon clicking
will simply create a word file and open it, and the merged records
will appear ready to be printed.

If somebody could please tell me the type of statements i need, or
point to a knowledgebase article that would be most appreciated.

Thanks In Advance.

Aaron

[asdfg2k]

On 31 Jul 2004 21:42:44 -0700, aa***@rapid-motion.co.uk (Aaron) wrote:

Hi People,

Does anyone know how to start a mail merge with ms access to ms word?

At the moment i select the records i wish to merge with a query, get
the results, then select Office Links from the menu that goes through
a wizard to acomplish the merge.

I would like to create a Command button on a form that upon clicking
will simply create a word file and open it, and the merged records
will appear ready to be printed.

Assuming that you want the Command button to create a new word
document that is based on an existing main document, then:

http://www.mvps.org/access/general/gen0010.htm

will give you the information you seek.

mike