Sending Email
<html> I have a table with a list of email address. I want to send email to all the receipients, at one shot, using script task. I don't want to send an email one by one. I want to use script task because the message is a formatted HTML. How to do it.
Thanks. </html>NSG12
March 29th, 2011 4:36pm
You could use the SmtpClient class:
http://msdn.microsoft.com/en-us/library/system.net.mail.smtpclient.aspx
Also see the Related Topics part on the left side. For example:
http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/2bb3d10b-9f1d-446f-8db0-b7f47510a7c9
Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2011 5:06pm
Thank you.NSG12
March 29th, 2011 5:42pm
you can also check
Sudeep's blog also..
Let us TRY this |
My Blog :: http://quest4gen.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2011 3:43am
Another option you can try is to get the addresses delimeted by semi-colon ';' and assign in the to, cc or bcc property of send mail task
1. Create an SP in the database that reads a column and assign the value to a string delimeted by semi-colon. A good sample of this kind is at
http://databases.aspfaq.com/general/how-do-i-convert-columns-of-values-into-a-single-list.html
2. Add an execute sql task. Call the SP created above and assign the return value to a variable
3. Add a send email taks and sets is To property to the value in the variable asssined in step 2
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
BH
March 30th, 2011 4:25am