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


    Mar 7, 2007
    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


    Mar 20, 2007
    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

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


Share This Page