Ergent - Sending Email

[Guest]

I writting an application to sending birthday email to all the customer, but I'm wondering is it must setup an email server ??? What is the simplest way ??? If I not mistaken, SQL Server 2000 can send email right ?? But How ??? Thanks

 

[Girish NS]

Hi,

yeah, SQL Server can be used to send mails using the SQLMAIL feature or
using COM objects from SQL Server Stored procedure.

HTH,

Girish.

I writting an application to sending birthday email to all the customer,

but I'm wondering is it must setup an email server ??? What is the simplest
way ??? If I not mistaken, SQL Server 2000 can send email right ?? But How
??? Thanks

 

[Guest]

Does SQLMail only used to send notification email ?? Can I used it for sending Birthday email ?? Is it appropriate ?? Thanks

----- Girish NS wrote: -----

Hi,

yeah, SQL Server can be used to send mails using the SQLMAIL feature or
using COM objects from SQL Server Stored procedure.

HTH,

Girish.

I writting an application to sending birthday email to all the customer,

but I'm wondering is it must setup an email server ??? What is the simplest
way ??? If I not mistaken, SQL Server 2000 can send email right ?? But How
??? Thanks