Email when new record added to table

[prepella]

Im using access 2000, and im new to access, what im trying to do is when a new record is added to a table, i would like it to automatically send an email of the record that was just added, how would i go about doing this, remeber this is new to me

THanks

Phil

 

[jfgambit]

Phil:
Is the data entered from a Form?

And how many records are entered a day? Seems to me that a number of e-mails will be sent if there are are many users.

It might be better to create a report of the daily data entered and have it e-mailed with a command button.

Below are a couple of articles on Sending Outlook messages via Access:

http://support.microsoft.com/default.aspx?scid=kb;en-us;318881
http://support.microsoft.com/default.aspx?scid=kb;en-us;209948

 

[mission2java_78]

Current event of your form:

If Me.NewRecord then
'send email
DoCmd.SendObject(args)
else
'old record do nothing
end if

Jon

 

[chewy]

Are you looking to bypass Outlook Security or just send with the confirmation?

 

[prepella]

What Im doing is filling in a form from a web page, that adds a record to a table, what has to happen is when the new record
gets added to the table all the information from that reocrd and only that record needs to be emailed to a dispatcher as soon as the record is entered into the database, sorry that i was not clear on this. My problem is how do i accomplish this, im very new to access.

Thanks Phil

 

[BukHix]

If you are gathering the information in a web form I would think it would be a better idea to trigger the email at the time of submission. Does the server your form is stored on support ASP?

 

[MadMaxx]

The web page you are using is it and ASP page?

If it is I can help. I created a quotes system that will e-mail the sales department when a company has uploaded a quote.