It Question - Primarily Sequel Server [Archive]

View Full Version : It Question - Primarily Sequel Server

legend

11-02-2006, 01:10 PM

For all the IT wizz kids out there, I have an issue

Sequel Server

I have a program called ERP and I would like to have an email sent to myself when an invoice on ERP is generated. Apparently I can generate a report on the Sequel Server database that will do this in the background.

This is for the purpose of tracking invoices & finances

Does anyone know how?

spuff

11-02-2006, 08:29 PM

Do a google search for "xp_sendmail" Should explain it for you there. It would still require some scripting based on your specific application.

spuff

11-02-2006, 08:30 PM

Actually - here you go, I will stop being lazy...

http://msdn2.microsoft.com/en-US/library/ms189505.aspx

legend

11-05-2006, 10:42 AM

Thanks Spuff, will give it a bash