Mail Merge

[quixote]

I have a form and on a button click I would like to
populate a Word document via mail Merge, attach it to an
email and send it. I know how to attach a document and
send it with VBA. Here is my problem. When I click the
button a new instance of the database opens and the mail
merge fields become invalid because the form fields don't
exist in the new instance of the database. How can I use
the current loaded form to populate a Word doc, then
attach it to an email and send it?

Thanks