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

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

Bulk Emails

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Windows Application
Hello guys, does SMTP server (gmail, yahoo, or any ordinary ones) have the right to block me for sending alotf emails, like 50,000 email ? iam no spamming or anything its just want to send each the invoice for each customer, another question, will it be a good thing to compress the resulted pdf file(invoice) before sending it ? or will it increase the load on my system?

View Complete Post

More Related Resource Links

sending bulk of emails


Hello guys

   I have a situation where i have to send around 50,000 emails with around 90kb attachment, each attachment will be generated by crystal reports then sent by email to the subscriber, what is the best practice for this? thanks alot

How to manage bulk emails in asp.net 2.0?


 Hey .Net Experts,

i want to discuss a scenario. what is the best way to send bulk emails with asp.net. like reminder emails. emails to all members of forum. or send news letters like that also send scheduled emails.

i have three scenarios in my mind. i need experts suggestions for these.

1) Run a loop  in code to send number of email


 for (i=0; i<= table.Rows.Count ; i++)


    SendEmail(to, from, subject, body); 

2) Write an .EXE file using desktop applications and run this .EXE file through SQL Jobs ETC, We have our own vps for this

3) Write a window service to send emails

please let me know about the best scenario for both efficency and speed. may be other than above three


Bulk Copy From Datatable To SQL Server Table


 I have read the data of a excle file and captured the data into the dataset to a datatable, now that data is to be inserted into a SQL Server table using bulk copy option. I am using -

 public bool BulkEnterData(DataTable dt, string tblName)
        SqlBulkCopy bulk = new SqlBulkCopy(con);
        bulk.DestinationTableName = tblName;

        return true;

ERROR Getting-
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) 

How to resolve the above problem or any other solution is available.


How do I get the emails of all the members of a given group in ActiveDirectory - Need help



  I have a need to send out emails to all the people who are in a given group say "HR Department". I need to be able to get all the emails through a for loop and then as it retrieves I should send emails to them. Can some one please help me with the code

this is what I came up with but not sure how to go about writing a for loop to get all the emails in the given group.

public static string SendEmails(string loginName)
        string Department = "HR Department"
        string userName = ExtractUserName(loginName);
        DirectorySearcher search = new DirectorySearcher();
        search.Filter = String.Format("(SAMAccountName={0})", userName);
        //search.Filter = String.Format("(SAMAccountName={FAY ImprovmentForm})", userName);
        //LdapSearcher.Filter = string.Format("(&(objectClass=user)(department={0}))", Department); 
        //search.Filter = string.Format("(&(objectClass=group)(SAMAccountName=" + Department + "))", userName);

How to send bulk sms from asp.net


Hi experts,

I want to send and receive sms in my asp.net website.I am currently targetting users in India.I may need to send the same sms to thousands of users at the same time.How can I achieve this?

Thanks in advance

Bulk Copy Operations in ADO.NET 2.0


Bulk copying of data from one data source to another data source is a new feature added to ADO.NET 2.0. Bulk copy classes provides the fastest way to transfer set of data from once source to the other.

Each ADO.NET data provider provides bulk copy classes. For example, in SQL .NET data provider, the bulk copy operation is handled by SqlBulkCopy class, which is described in Figure 1. As you can see from Figure 1, data from a data source can be copied to one of the four types - DataReader, DataSet, DataTable, or XML.

SPD workflow, emails sent for one user, not for the other


Good day,

I have a SPD workflow (WSS/2007) that take a date field from a document list and when that date occurs it sends an email.  If the date is in the past, it will send the email out right away.  It is working fine for one user, not for another.  Both users have the same permissions.  The workflow goes as follows:

ACTION: Set Variable: vTermdate to DocumentsNotificationDate
       then log Documents:Email Date to the workflow history list

CONDITION: if Variable: vTermdate is not Empty
ACTION: Log term not empty to the workflow history list

CONDITION: if Variable: vTermdate is Empty
ACTION: Set Variable: vTermdate to N/A

ACTION: Add 0 minutes to Documents:Email Date (out to

Email enabld list delay on recieving emails


So the situation is, i have a list, that receives emails from a particular account all day long, recently it has started recieving emails "late" being it will mass process emails at various times of the day. Before it proccessed them as soon as they were received.

Event log shows

A critical error occurred while processing the incoming e-mail file C:\Inetpub\mailroot\Drop\e472144001cb44a40000001e.eml. The error was: The process cannot access the file 'C:\Inetpub\mailroot\Drop\e472144001cb44a40000001e.eml' because it is being used by another process..


Have this error everywhere.

        -Restarted SMTP

        -Restarted IIS

It seems SMTP is having issues but wanted to come here and get some insight.


-I havent changed anythign recently except new cable runs to the switch

-There is no mail in the (Drop, Mailbox,Pickup, Queue) folders

-mail setup settings are

              -incoming is set to "Advanced" , no,  server.domain.com

Outgoing is my exange server.



smtp server 5.1 in xp not sending emails


hi iam using asp.net 2.0 with c#.net.

in my application when client completes its shopping email will goes to user this works fine when there is internet connection is working fine,
if  there is some problem  in internet connection if one mail stops then all the mails will be stopped even now internet works fine,

how to resend the emails using smtp server, is there any option to resend the emails automatically when internet works fine.

can you give example which helps me.


Can I bulk insert to specific columns when bulk inserting a text file or do I have to bulk insert into all columns of a table? The extra column in the table is an identity integer. So I had to create a view without the identity integer to make it work. Maybe there is a more direct way?? If so what would be the syntax? I am a beginner to intermediate SQL guy.   strSQL = "BULK " & _        "INSERT CustomersUpload " & _        " FROM 'C:\MydataFile.txt' " & _        " WITH " & _        " ( " & _        " FIELDTERMINATOR = '|', " & _        " ROWTERMINATOR = '\n' " & _        " )" Thanks

.net 3.5 in conjunction with CRM 4.0 email router adding code to subject line of emails causing spam

We use CRM 4.0, which is using .net framework 3.5 SP 1.  Emails sent out of CRM go through and email router and the subject line of these emails is getting "=?us-ascii?Q? added to the beginning of the subject line and "?= added to the end of the subject line. This is causing a large amount of our emails getting spammed. I was told by the CRM support that this is an issue with .net 3.5 and won't be fixed until .net 4.0, which CRM won't support for another year.  Is there not a .net 3.5 patch that can address this?

System.Data.SqlClient.SqlException: Bulk load data was expected but not sent

Hi everyone We've had this error twice now from our C# code. Nothing is changing the columns, but I've noticed though that it appears to happen when two threads are attempting to bulk insert into the same table, generally millions of rows. The docs say that SqlBulkCopy.WriteToServer is not guaranteed to be thread-safe, but is this the problem here? It feels like it. I've seen some posts where people appeared to have experienced problems in similar circumstances (http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/85d51484-6381-46bc-bcce-63b58b362d2d). There is no identity column just a non-unique clustered index that is (spid) process keyed to each thread. Do I need to synchronise access to the table for WriteToServer - is this a known problem? Many thanks Reg --- System.Data.SqlClient. SqlException: Insert bulk failed due to a schema change of the target table.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()   at System.Data.SqlClient.SqlBulkCo

Duplicate emails are being sent

Hello I am using SPutility.SendEmail method to send the email to the particular recipient internally using case statement. I mean depending on the dropdown selection I am sending email by making the selected values in case statement. Here the issue is the users are complaining that they are getting multiple emails for the same request. When I checked in my dev server the flow of the code is normal but not the same case with prod. The following is the code. case "mycase":                             {                                 StringDictionary headers = new StringDictionary();                                 headers.Add("from", fromemail);                                 headers.Add("to",   toemail);        

Bulk amount of data in List

Hi All, I got a requirement that to display bulk amount data in a List (Around 50000 items). Can any one of you suggest me best performance way?(Displaying this amount data would definitely leads to performance issue). Let me know if you have any Queries.   Regards, Kumar.

doing bulk update

Hello Everyone, I have a gridview. users can update the database using this gridview. There are about 10 columns and 60 rows in this gridview and once the user makes the changes to a particular row, there is an update button on that row and user can click that button to update the changes that he/she made. My boss wants to remove the update button from each row and put the button at the bottom of the gridview. he says that I will make the changes to whatever rows, I want to make the changes to and then hit the update button that is at the bottom of the grid and it should make the changes to all the rows in the database. I can accomplish this by opening the database coonetion and making a call to the database several times and updating row one by one or I can do all bulk insert. how can I acheive this bulk insert because the other option is quite expensive. Please let me know if anyone has any ideas. Thanks in advance  

Best Way to Send Multiple Emails

I'm building a website that allows users to post comments. When they do, they can check a box that indicates if they want an email notification when someone else posts a comment under the same topic. (Similar to this web site.)This means when a comment is posted, the code has to send an email to all the subscribed users.My concern is about what happens when many users are subscribed to a topic. There is a short delay when sending an email. Sending dozens or potentially even hundreds could really cause a delay.Right now, I just loop through each user and send the emails one by one. Does anyone know if that's the best way?Thanks!

Errors during bulk insert

Hi, While writing a stored procedure in SQL 2008, for a bulk insert, I am getting several errors. Part of the SP is written below for your reference. Need to know where am I going wrong. Any help will be thankfully acknowledged.-Learn24x7----------CREATE PROCEDURE Sp_BulkInsert(@Directory nvarchar(256), @TblName nvarchar(50), @Collation nvarchar(50), @FieldSeparator nvarchar(50),    @RowTerminator nvarchar(50))ASBEGIN    SET NOCOUNT ON;                BULK INSERT [@TblName]    FROM ''+@Directory+'' --Error1: see below    WITH --Error2: see below     (     FIRSTROW = 2,     CODEPAGE = (SELECT CAST(@Collation AS INT)), --Error3: see below     FIELDTERMINATOR = ''+@FieldSeparator+'',     ROWTERMINATOR = ''+@RowTerminator+''     )  ENDGO----------FROM ''+@Directory+'' --Error1: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.WITH --Error2: Incorrect syntax near the keyword 'with'. If this statement is a commo
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