Office 2010 - Access Automate Merge to Word then Send from Outlook

[app2tude]

I am using Office 2010 for our company's integrated business application. 2010 has very limited help facilities.

I want to Automate the following:

1. Select people from our Access Query.
2. Merge the names from the query list into a Word document.
3. Send the merged document as an Outlook email.

I would prefer to use standard Access Macros to perform this function every time the send email button is clicked.

Any Ideas?

 

[thingssocomplex]

Not sure if this would be of any help

1. Create your query to select the names
2. Not sure what you mean by merge!
3. Create a report in access to capture the names
4. With Access 2010 you can create a button using the built in Macro to attach the report to an email in either .Doc or .PDF