Email notification service architecture help

[v_ganeshraju]

Hi,

I need to send notification email on a specific change to a field in database table. I need to also track if the email was delivered or not. If the email is not delivered, it should be logged for a different process. Can someone please help me to architect an efficient design. IS it good to go with sql 2005 notification service? or a simple windows service component? It is .NET c# application. Please give an overview of architecture and design, any help with code will also be appreciate.

Thanks,
Ganesh

[Hack]

So, the bottom line here is that you want to send an email message using C# right?

[v_ganeshraju]

Yes, but also need to track if the email got bounced back.

[Hack]

One step at a time.

For sending, check this out.