How do I read a list of email address and send out email with attachment through an SMTP server in SQL 2005/2008 Express?

Last post 06-30-2008 2:03 PM by tingshen. 0 replies.

Page 1 of 1 (1 items)
	Sort Posts: Previous Next

06-30-2008 2:03 PM

tingshen
Joined on 06-26-2008
Posts 1

How do I read a list of email address and send out email with attachment through an SMTP server in SQL 2005/2008 Express?

Reply Contact

I understand that Database mail is not enabled in the express edition for 2005. Is it available it 2008 express?

There is a workaround here: http://weblogs.sqlteam.com/mladenp/archive/2007/07/01/60245.aspx but I'm not sure if it's "legal" to do so, coz you're copying the Database mail files over to use it.

Is there any 3rd party software or a more "legal" workaround to do so?

I just want to send email based on a table:

Email Attachment

abc@abc.com c:\download\abc.xls

def@def.com c:\download\def.xls

Page 1 of 1 (1 items)

SG SQL Server Usergroup