.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

System.Net.Mail - adding multiple recipients from a table

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :ASP.Net


I have been google some but I can´t find any solution that have been worked for me. I do use System.Net.mail on my site to send emails to individual employes. Now I would like to be able to email all emplyees. The emplyees email address is stored in a MS SQL table. Is it possible to make a BCC email to all employees in that table?

Best regards Daniel

View Complete Post

More Related Resource Links

Sending a Mail Message to Multiple Addresses Using System.Net.Mail

 VWD 2008 Express.  Visual Basic. I use the following routine (XXXXX have replaced sensitive data) to try to send an email message to mutiple email addresses.  It only sends to the first email address in the comma-delimited list.  How can I send the message to multiple email addresses?  Thanks for the help. Protected Sub SendButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SendButton.Click 'Send the message to all users who have emails. Dim smtpClient As SmtpClient = New SmtpClient() Dim message As MailMessage = New MailMessage() Dim Success As Boolean, I As Integer, strTO As String = "" Try 'Gather all user email addresses Dim strSQL = "SELECT EMail from aspnet_membership where Email<>''" Dim MyDataset As DataSet = GetDataSet(strSQL, Success) I = 0 For Each dr As DataRow In MyDataset.Tables(0).Rows If I = MyDataset.Tables(0).Rows.Count - 1 Then strTO = strTO + dr("Email") Else strTO = strTO + dr("Email") + "," End If I = I + 1 Next Dim toAddress As New MailAddress(strTO, "To All Users") 'Ga

Adding a table or view multiple times when building a query with BI Report Designer and Report Build

How can I add a table/view multiple times to a single query by using BI Report Designer or Report Builder 3.0? In Report Designer I managed (workaround) to add one table multiple times by creating multiple Named Queries and having the same SELECT. Still I don't know how to add one table multiple times in Report Builder 3.0.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

Adding the table row below a particular row.


What is the best method in jQuery to add an additional row to a table as the row below a particular row?

merging multiple tables in a single dataset to single table


 i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset 

like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid  as a compact data and combination of 3 tables from d single dataset.....

can some1 help me please.....

Email Help (System.Net.Mail)


Hi I have a annoying problem. 
I have created a page which takes users details for a quote.

I have then created the form to be emailed to both the user and myself. (Which works fine ATM)

However I would also like to be able to attach a file containing terms and conditions to the email.

I have tried doing this using 

EmailMsg.Attachments.Add(new Attachment("C:\\attachme.txt"));

But everytime that line of code is hit it fails and is caught by my try catch.

Take that line out and the email sends fine, put it in and it breaks the whole page.

Am I missing something really obvious?

Adding table to a page, but the format lost when I use clear border



I added a table to a page, by default, the table layout is the light border. So, I add my content and the vertical align seems to set to the top. But when I changed it to clear border, the content of the table will set vertical align to center. Is there a way to change this back to top align but with the clear border. I don't think I can do this by what is available in the ribbon. Please advice.

system.net.mail cc issue


I have an array of addresses.....

	Protected Function GetData() As String()
Dim stringArr(3) As String

stringArr(0) = "youremail1@fakeaddress.com"
stringArr(1) = "youremail2@fakeaddress.com"
stringArr(2) = "youremail3@fakeaddress.com"

Return stringArr

End Function

I am getting an error when i run the code in the CC part....please put this in the right syntax..

MassMail.CC.Add() .......getdata???

System.Net.Mail HTML Template Problem


What do I need here ?????? To make this work??

Dim MassMail As New MailMessage()

        Dim Template As ??????????????

        MassMail.To.Add(New MailAddress(TextBox_massemailto.Text))
        MassMail.From = New MailAddress("You@me.com")

        ' MassMail.CC.Add()
        MassMail.Subject = TextBox_massemailsubject.Text
        MassMail.Body = TextBox_massemailBody.Text
        ' MassMail.Body = Template.BodyFileName = "EmailTemplates/BusinessAdBrochure.htm"
        MassMail.Priority = MailPriority.High

        Dim smtpclient As New SmtpClient("relay-hosting.secureserver.net")
        smtpclient.Credentials = New System.Net.NetworkCredential(""You@me.com"", "pasword")
        smtpclient.Port = 25
        smtpclient.EnableSsl = False

System.AddIn, simultaneous multitouch interaction in multiple addins

Hello, I have built an application that is able to load several addins, each having their own process, each sending their own UI onto the application's UI. I now would like to enable simultaneous multitouch interaction in any of these AddIns' UIs. The problem is: when there is multitouch interaction ongoing in one of the addins' UI, the others do not seem to receive any event, even though I try to touch controls in them. My question is: is this even possible in the current form of the framework? Or does the input device (i.e. my touch screen) get somehow "captured" by the currently manipulated UI's process, thus preventing the others from getting any input at all? Antoine

System.Net.Mail.SmtpException: net_io_connectionclosed

I'm getting "System.IO.IOException: Unable to read data from the transport connection: net_io_connectionclosed." but only occasionally.  I'm confused because:1) The SMTP server is the local machine so why would the connection ever fail? and2) The error only happens sometimesThere was a similar question posted here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=418540&SiteID=1 but it seems they were having problems sending any mail to begin with.Here is the full stack trace:System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Unable to read data from the transport connection: net_io_connectionclosed.   at System.Net.Mail.SmtpReplyReaderFactory.ProcessRead(Byte[] buffer, Int32 offset, Int32 read, Boolean readLine)   at System.Net.Mail.SmtpReplyReaderFactory.ReadLines(SmtpReplyReader caller, Boolean oneLine)   at System.Net.Mail.SmtpReplyReaderFactory.ReadLine(SmtpReplyReader caller)   at System.Net.Mail.SmtpReplyReader.ReadLine()   at System.Net.Mail.CheckCommand.Send(SmtpConnection conn, String& response)   at System.Net.Mail.DataStopCommand.Send(SmtpConnection conn)   at System.Net.Mail.SmtpConnection.OnClose(Object sender, EventArgs args)   at System.Net.ClosableStream.Close()   at System.Net.Mail.MailWriter.Close()   at System.Net.Mail.SmtpClient.Send(MailMessage message)I'm unable to recreate this error since it onl

unable to create new table in sql server 2000 enterprise manager on windows7(Operating system)

i have successfuly installed sql server 2000 on windows7 and i am able to browse all the tables and edit aswell(on enterprise manager) but i have a problem while creating new tables it says ' MMC has detected an error in a snap-in' and provides options to either continue with the error or send a report to microsoft ,   Please help regarding this compatibility issue   Thanks in advance !

System.Net.Mail.SmtpException was caught

i am trying to implement this in my application to send a mail but i keep getting this error i configured in my web.config<system.net>        <mailSettings>            <smtp from="dep-it@public-health.gov.lb" deliveryMethod="Network">                <network host="mail.ogero.gov.lb" password="" userName="" port="25" defaultCredentials="true"/>            </smtp>        </mailSettings>    </system.net>and this is the code i'm using :Public Function SendMail(ByVal strTo As String, ByVal strSubject As String, ByVal strMsg As String, ByVal path As String) As Boolean        'ByVal strFrom As String,        Try            ' Create the mail message            Dim objMailMsg As MailMessage = New MailMessage("dep-it@publichealth.gov.lb", strTo)            objMailMsg.BodyEncoding = Encoding.UTF8 &nbs

Adding data from Excel spreadsheet to SQL table

This is not a programming question, I simply have a lot of data in two columns in an excel spreadsheet of data that I gathered.  I want to copy and paste this (manually) into a table that I have created in my ASPNETDB in my ASP.NET web application.  I thought it'd be as easy as copy the column, and hit paste in the "table data" view, but it's not (it only pastes one cell).Is there a way for me to manually copy data from excel and paste it in a table in my SQL Server?Thanks in advance! :)

Email Encryption using System.Net.Mail assembly

Hi folks, Has anyone used the above assemblies to send emails using public key enryption, specifically PGP? Cheers Mark 

Adding multiple holidays to a SharePoint Calendar

I have a need to add US, Canadian and UK holidays to a corporate wide calendar. Is there a way to have SharePoint auto input these holidays for me or do I have to add them into a calendar overlay by hand. I can have outlook add holidays automatically it seems odd that SharePoint can't. Any suggestions?

How 2 join Multiple Keys based table???

I have a table INC with 2 Columns/Fields, i.e. YR and CL set as primary keys by selecting both the columns and selecting primary key symbol with right click. How to set up a FK with the other table INC_DTL's CL which I seek to be restricted to a combination of the INC's 2 fields? Thanx in advance.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend