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
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
"Pommy_g" <po*****@hotmai l.com> wrote in message
news:5d******** *************** ***@posting.goo gle.com...
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