generating automatic email notification of new record from web

H

havenoclue

I'm fairly new to this stuff, so forgive me if I ask the wrong questions. I
have an online database app that is submitted to an access database. What I
want is when a new request is submitted, an automatic email is generated and
sent to multiple persons with that record as an attachment. Does anyone have
any suggestions?
I have searched for the past several days, but cannot seem to find the right
answer. Any help would be greatly appreciated.
 
A

Alex Dybenko

Hi,
you can use Docmd.Sendobject to send emails in Access
if your forms are web forms - then better ask at ASP/ASP.net newsgroups
 
H

havenoclue

I have the Docmd.SendObject. How do I use this now? I would like the table
to be emailed everytime a new record is added without having to go in and
manually send the info.
 
A

Alex Dybenko

Hi,
if records added via form - then you can use AfterUpdate form's event - just
run Docmd.SendObject method with desired arguments - see online help for
more info
 
D

David C. Holley

You can't do that from within Access. However, it is possible to write a
server-side script that generates the emails and sends the data.
 
H

havenoclue

David.

I have the serverside script written. My problem now is that I can't attach
the table. I can only attach the whole database. Would like to attach and
send the current row added.
Any idea?
 
D

David C. Holley

Why do you need to send the table? My inital thought was that you needed
to send everyone a copy of the data added which would be a matter of
creating email to them with the data.
 
Top