By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Emailing Data...

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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*****@hotmail.com> wrote in message
news:5d**************************@posting.google.c om...
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.