Access 2007: Send record as email?

[r.j.s]

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?

 

[bmcgonag]

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