|
 |
access thread: Generate an Email Automatically when a Row has been inserted
Message #1 by pritesh_b@t... on Thu, 10 May 2001 17:54:19
|
|
Hi
I am using Access 2000 and i was wondering if it is possible to generate
an email and send it when a new record has been inserted.
the Database is connected to a ASP form where users enter there details
which inserts the information in my database.
Since i do not want to monitor the database on a regular basis i wondered
if i can create i trigger which will do the above function.
Thanks
Pritesh
Message #2 by Ken Clark <clarkk@w...> on Thu, 10 May 2001 10:35:03 -0700
|
|
checkout Persists Software @ http://www.aspemail.com/
At 5/10/2001 , you wrote:
>Hi
>
>I am using Access 2000 and i was wondering if it is possible to generate
>an email and send it when a new record has been inserted.
>
>the Database is connected to a ASP form where users enter there details
>which inserts the information in my database.
>
>Since i do not want to monitor the database on a regular basis i wondered
>if i can create i trigger which will do the above function.
>
>Thanks
>
>Pritesh
Ken Clark
Supervisor, IT Graphics
Washington State University
Pullman, WA 99164-1222
xxx-xxx-xxxx
Message #3 by "Pardee, Roy E" <roy.e.pardee@l...> on Thu, 10 May 2001 10:30:54 -0700
|
|
Access does not support triggers, unfortunately. Maybe you could put calls
in your ASP front-end to acheive the same effect?
HTH,
-Roy
-----Original Message-----
From: pritesh_b@t... [mailto:pritesh_b@t...]
Sent: Thursday, May 10, 2001 10:53 AM
To: Access
Subject: [access] Generate an Email Automatically when a Row has been
inserted
Hi
I am using Access 2000 and i was wondering if it is possible to generate
an email and send it when a new record has been inserted.
the Database is connected to a ASP form where users enter there details
which inserts the information in my database.
Since i do not want to monitor the database on a regular basis i wondered
if i can create i trigger which will do the above function.
Thanks
Pritesh
Message #4 by "Rogers, Robert" <rrogers@b...> on Thu, 10 May 2001 14:28:45 -0400
|
|
There is an easier way to get data from Access to you in Outlook, and that
is through a macro action "SendObject"
or use VBA "docmd.sendobject".
v/r
Robert L. Rogers
Application Developer, Rexel Branch Electric
(xxx)-xxx-xxxx
-----Original Message-----
From: Ken Clark [mailto:clarkk@w...]
Sent: Thursday, May 10, 2001 1:35 PM
To: Access
Subject: [access] Re: Generate an Email Automatically when a Row has
been inserted
checkout Persists Software @ http://www.aspemail.com/
At 5/10/2001 , you wrote:
>Hi
>
>I am using Access 2000 and i was wondering if it is possible to generate
>an email and send it when a new record has been inserted.
>
>the Database is connected to a ASP form where users enter there details
>which inserts the information in my database.
>
>Since i do not want to monitor the database on a regular basis i wondered
>if i can create i trigger which will do the above function.
>
>Thanks
>
>Pritesh
>
Message #5 by "Derrick Flores" <Derrick_Flores@s...> on Fri, 11 May 2001 08:09:21 -0500
|
|
DoCmd.SendObject acReport, "ReportName", "RichTextFormat(*.rtf)",
"SendTo", "SendCC", "SendBcc", "Subject", "MessageText", True, ""
You can used this VBA code to send a report to an email address. You can
replace the "SendTo", "SendCC" ... with Varibles that may get its data
from a form or from other sources.
Derrick A. Flores
Associate Systems Engineer
6" Line Engineering
Sony Electronic Inc.
Semiconductor San Antonio
1 Sony Place M/S 730
San Antonio, Texas 78245-2100
Telephone: (xxx) xxx-xxxx
Fax: (xxx) xxx-xxxx
Pager: (xxx) xxx-xxxx
E-mail: derrick_flores@s...
>>> "Rogers, Robert" <rrogers@b...> 05/10 1:28 PM >>>
There is an easier way to get data from Access to you in Outlook, and that
is through a macro action "SendObject"
or use VBA "docmd.sendobject".
v/r
Robert L. Rogers
Application Developer, Rexel Branch Electric
(xxx)-xxx-xxxx
-----Original Message-----
From: Ken Clark [mailto:clarkk@w...]
Sent: Thursday, May 10, 2001 1:35 PM
To: Access
Subject: [access] Re: Generate an Email Automatically when a Row has
been inserted
checkout Persists Software @ http://www.aspemail.com/
At 5/10/2001 , you wrote:
>Hi
>
>I am using Access 2000 and i was wondering if it is possible to generate
>an email and send it when a new record has been inserted.
>
>the Database is connected to a ASP form where users enter there details
>which inserts the information in my database.
>
>Since i do not want to monitor the database on a regular basis i wondered
>if i can create i trigger which will do the above function.
>
>Thanks
>
>Pritesh
>
Message #6 by pritesh_b@t... on Mon, 14 May 2001 18:35:20
|
|
Thank you all very much for your help.
> Hi
>
> I am using Access 2000 and i was wondering if it is possible to generate
> an email and send it when a new record has been inserted.
>
> the Database is connected to a ASP form where users enter there details
> which inserts the information in my database.
>
> Since i do not want to monitor the database on a regular basis i
wondered
> if i can create i trigger which will do the above function.
>
> Thanks
>
Message #7 by "Derrick Flores" <Derrick_Flores@s...> on Mon, 14 May 2001 15:32:18 -0500
|
|
Try using docmd.sendobject
Derrick A. Flores
Associate Systems Engineer
6" Line Engineering
Sony Electronic Inc.
Semiconductor San Antonio
1 Sony Place M/S 730
San Antonio, Texas 78245-2100
Telephone: (xxx) xxx-xxxx
Fax: (xxx) xxx-xxxx
Pager: (xxx) xxx-xxxx
E-mail: derrick_flores@s...
>>> <pritesh_b@t...> 05/14 6:35 PM >>>
Thank you all very much for your help.
> Hi
>
> I am using Access 2000 and i was wondering if it is possible to
generate
> an email and send it when a new record has been inserted.
>
> the Database is connected to a ASP form where users enter there
details
> which inserts the information in my database.
>
> Since i do not want to monitor the database on a regular basis i
wondered
> if i can create i trigger which will do the above function.
>
> Thanks
>
|
|
|
View Cart
