Sending a record via email

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

I have written a an IT Support Job Database, my boss wants
me too add some more features too it.

Is it possible to send a record in a form as an email?
When you click a button? If so any ideas/ solutions?

Many THanks

Jamie
 
Jamie,
Is it possible to send a record in a form as an email? < Yes, definitely

When you click a button? < Yes.
If so any ideas/ solutions? <

The first technique you might want to consider is using the SendObject
method in Access. SendObject will send the data associated with a Form,
Query or Report (as well as other objects). If you want to send *only* one
record, you would need to create a Query or Report that returns only the
record to be emailed; in the Form you would need to be sure that the
RecordSource of the form contains only the record you wish to send.

Another technique to consider is to use Outlook Automation (presuming that
you use Outlook as your email client). Here are a couple of links to
articles on the subject (the first link has very easy to follow code
samples):

MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Also, have a look at Tony Toews' email page:

http://www.granite.ab.ca/access/email.htm
 
Back
Top