How to mail

[gurlprogrammer]

We have an SQL database on our website and our customers complete a form and submit. The data goes into our SQL database (this part works fine).

However, we would also like for the data to be emailed to us and we can't figure this part out.

Any help would be greatly appreciated.

thanks,
TJ

 

[Rosko]

I used the xp_sendmail procedure in a trigger and it sends the inserted data to the necessary mailaccounts. Make sure your mail session runs with a valid MAPI account. In my case I've created a domain user account (same name as the server) which is the startup account for the server. And the mail session of the server uses the mailbox of the startup account. It works perfectly that way.

Hope this was enough to help you.

GL
Rosko