Access 2007: Send record as email?

Discussion in 'Windows, Linux & Others on the Mac' started by r.j.s, Oct 29, 2009.

  1. r.j.s Moderator emeritus

    r.j.s

    Joined:
    Mar 7, 2007
    Location:
    Texas
    #1
    In Access 2007, I want to be able to create something that will take the current record, and send it to a contact.

    I want it to make one of the record's fields the subject and use the record's attachments as the email attachments.

    I can create a macro to send the entire table, but I only need to send one record at a time.

    Any ideas?
     
  2. bmcgonag macrumors 65816

    bmcgonag

    Joined:
    Mar 20, 2007
    Location:
    Texas
    #2
    I've done this in 2003, not 2007...but there are a couple of ways to go.

    You can setup the sendmail through outlook, there is code to do it, and it does have to be coded in. But you can use the code to select the information in the record displayed on a form at that time.

    You can also export the record as a pdf version of a report, but that also takes coding.

    Best place to look is www.utteraccess.com

    They are gurus, and the code for both of these methods is already there I believe.

    Brian
     

Share This Page