generating automatic email notification of new record from web

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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
 
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.
 
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?
 
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.
 
Back
Top