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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • improveit4
    New Member
    • Aug 2010
    • 2

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

    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
    Moderator Top Contributor
    • Oct 2006
    • 1288

    #2
    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

    Comment

    • jimatqsi
      Moderator Top Contributor
      • Oct 2006
      • 1288

      #3
      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.

      Comment

      • zmbd
        Recognized Expert Moderator Expert
        • Mar 2012
        • 5501

        #4
        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

        Comment

        Working...