Hi,
I was wondering if somebody could point me in the right direction here.

What I want to be able to do is maintain a database table of subscribers (email addresses, subscription categories) and then automate the sending of an email to each subscriber at a set time each day.
The email would automatically generate itself based on news content from another database table.

I've tried googling but I don't think I'm searching under the right words because I'm coming up with next to nothing that is helpful.

automate the sending of an email to each subscriber at a set time each day -- Create a job in SQL server runts at scheduled time (it can call a stored procedure)

Use xp_smtpsendmail to send e-mail (download here http://www.thorpesoftware.com/readme.htm)

for HTML stuff use sp_makewebtask (look in the books online)

Okay, that appears to make sense so far although I'll need to do a fair bit of research on creating stored procedures because my knowledge in that area is quite cloudy.

Regarding the recipients, how can I send the email so that each recipient the email goes to cannot see the email addresses of the other recipients. Is there some form of mailing list integration with Microsoft Exchange Server that I could do?

store all the recipient e-mails in a staging table..then loop through the table (use cursor fetch a record send an e-mail then fetch another record..I hate to use cursor but.. )

Thanks for your help.

I also just managed to come across this Microsoft article that could be a useful way of achieving the task too.

http://support.microsoft.com/kb/q221495/