Emailing Data...

  • Thread starter Thread starter Pommy_g
  • Start date Start date
P

Pommy_g

Hi, i have done some searching on the newsgroups for this problem but
have had no luck.

Basically i have a query, and what i need is a button that when
clicked on sends an email to whoever, containing the the data from the
query. Then i need the data that was sent, to go into another query
(preferably once the email has actually been sent as opposed to once
the button has been clicked)

Can anyone help out here?

TIA
Salman
 
There are a couple of different ways to send either Access objects or Access
data via email:

First, in VB Help check out the SendObject method, which allows you to send
an Access object (query, report, module, etc.) as an attachment to an email.
If you do not want to send an email attachment, you might want to
investigate using Automation with Outlook, a means by which you can use the
Outlook Object Model to create your email message using Access data, select
recipients, etc., using VBA. There is sample code at the following links
that can get you started:

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