send email with data from table and attach a word doc from access 2010

[improveit4]

I am a High school volunteer who would like to send a email to each contact in my access 2010 table with selected fields from their record. I would like to be able to attach a word doc to this email.

Purpose is for each High school parent to get a email where they can confirm their basic info we have on them (in access table)for purposes of publishing in a school directory. I would like to attach an order form to this email.

I currently have 1 table in access that holds all 1100 records

step by step instructions would be helpful.
I tried to do this with the email function in the ribbon, but i couldn't attach an order form.

Thanks

[jimatqsi]

This is a pretty frequent topic here at Bytes. Try searching for threads on Google with "vba access 2010 send email site:bytes.com" You'll get a lot of reading material. :)

Jim

[jimatqsi]

Most often the solution involves Outlook. But you can avoid Outlook altogether by using the CDO email method. That usually requires a network administrator to give you some help through the security system.

[zmbd]

I just covered this a few threads ago and you should read thru the automation document in the Insights acticles (#163) that covers this fairly well too:
Microsoft Access / VBA Insights Sitemap:
163.Application Automation