Maximum Mails That can be sent frm outlook

Discussion in 'Internet & WWW' started by grinning_devil, Apr 5, 2006.

Thread Status:
Not open for further replies.
  1. grinning_devil

    grinning_devil New Member

    Joined:
    Dec 3, 2004
    Messages:
    1,046
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    South Side Crater, Mars
    If i wanna send 1000 mails from outlook 2003 in one go , will that be possible?
    Is there any limit to it ??

    pls do let me have the web site address with ur post..
    and dont post like this --
    yes i think u can...
    shuld be possible ...
    etc
    etc
    :wink:
     
  2. QwertyManiac

    QwertyManiac Commander in Chief

    Joined:
    Jul 17, 2005
    Messages:
    6,656
    Likes Received:
    10
    Trophy Points:
    0
    Yes its possible, also for more mass try this >
    Mass Mail

    But sendin so many at once will trigger a spam rater i think...
     
  3. OP
    OP
    grinning_devil

    grinning_devil New Member

    Joined:
    Dec 3, 2004
    Messages:
    1,046
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    South Side Crater, Mars
    lol....i checked that already...
    actually i want to know if i mail 1k users from outlook,will that be possible??
    mean is there any limit to number of users we can send a mail to ??
     
  4. ilugd

    ilugd Beware of the innocent

    Joined:
    Dec 25, 2005
    Messages:
    1,009
    Likes Received:
    3
    Trophy Points:
    0
    Possible from outlook. It is simple if you know vba.

    or you can use another language and create an outlook message object and all that stuff. I have done that from excel to send the SAME email to DIFFERENT people. I created a sheet with the names and email addresses etc. Then i used the code to send it. I will find where i have the code and post it.

    Ok, so the problem is that for each email, outlook asks you that a program wants to send mails. Press the Cancel button to cancel. And what is more that you have to wait for around 5 seconds before each one is sent. So if you want to do it for 1000 email, be prepared to wait for 5000 seconds or something.

    BTW, what are you trying to make? a mail bomber? Anyway let me know. But since i can think of quite a few legal applications, i will go ahead and post the code, however please note why i made this program and make the changes appropriate for your situation yourself. Since you are an active contributor to the forum, i think you can handle it. If you need any help, just let us know.

    Here is the code.
    Oops, first the excel column structure

    1. Name of the person to whom you are sending.
    2. Data field
    3. Email address
    4, 5 Other Data fields

    So here is the code.
    Code:
    Private Sub cmdOK_Click()
    On Error Resume Next
    Dim wsReport As Worksheet
    Dim BodyText As String
    Dim rwReport As Integer, rwI As Integer
    Dim bStarted As Boolean
    Dim oOutlookApp As Outlook.Application
    Dim oItem As Outlook.MailItem
    Set wsReport = ThisWorkbook.Sheets("Sheet2")
    Set oOutlookApp = GetObject(, "Outlook.Application")
    If Err <> 0 Then
        Set oOutlookApp = CreateObject("Outlook.Application")
        bStarted = True
    End If
    rwReport = 1
    Do While wsReport.Cells(rwReport, 1) <> "" Or wsReport.Cells(rwReport, 5) <> ""
        If wsReport.Cells(rwReport, 3) = "" Then
            wsReport.Cells(rwReport, 4).Font.Bold = True
        Else
            Set oItem = oOutlookApp.CreateItem(olMailItem)
            With oItem
                'Set the recipient for the new email
               .To = wsReport.Cells(rwReport, 3)
                .Subject = "AY Annual Report 2005 information required"
                BodyText = "Dear " & wsReport.Cells(rwReport, 1) & vbCr _
                  & "Greetings from #### ####, New Delhi!" & vbCr _
                  & "Please find below the list of languages/programmes for which we have not yet received the annual letter response monthwise report for 2005. Please do send the same at the earliest. If you have already sent the mail, please forward it again to ########.###" & vbCr
                BodyText = BodyText & ">" & wsReport.Cells(rwI, 5) & vbCr
                rwI = rwReport + 1
                Do While wsReport.Cells(rwI, 1) = "" And wsReport.Cells(rwI, 5) <> ""
                    BodyText = BodyText & ">" & wsReport.Cells(rwI, 5) & vbCr
                    rwI = rwI + 1
                Loop
                rwReport = rwI - 1
                BodyText = BodyText & vbCr & "Thanking you." & vbCr _
                  & "Yours Sincerely," & vbCr & vbCr & "Jeba Singh Emmanuel" _
                  & vbCr & "Assistant Media Director, Radio AY"
                .Body = BodyText
                .Send
            End With
        End If
        rwReport = rwReport + 1
    Loop
    If bStarted Then
        'If we started Outlook from code, then close it
        oOutlookApp.Quit
    End If
    Set oItem = Nothing
    Set oOutlookApp = Nothing
    Unload Me
    
    End Sub
    
     
  5. ilugd

    ilugd Beware of the innocent

    Joined:
    Dec 25, 2005
    Messages:
    1,009
    Likes Received:
    3
    Trophy Points:
    0
    LOL, as i was writing the long post, you seem to have reposted, so i am just answering. I don't know if outlook rejects such an attempt. I think you just have to try and find out.

    Good question.
     
  6. OP
    OP
    grinning_devil

    grinning_devil New Member

    Joined:
    Dec 3, 2004
    Messages:
    1,046
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    South Side Crater, Mars
    thanx a lot ilugd for the trouble man...
    i was a little curious on the number of emails that can be sent from outlook...there has to be some limit!
     
  7. ilugd

    ilugd Beware of the innocent

    Joined:
    Dec 25, 2005
    Messages:
    1,009
    Likes Received:
    3
    Trophy Points:
    0
    most probably not. They develop such software for major corporations which may need to send emails to thousands of customers. They want developers to develop plugins (?) for outlook to extend its functionality. Since microsoft was never known for its ethics anyways, so i would be surprised if they had a limit.

    Implementation wise, the feature (spam filtering in outgoing mails) is the responsibility of the smtp server (or whichever) and not of the client.
     
  8. OP
    OP
    grinning_devil

    grinning_devil New Member

    Joined:
    Dec 3, 2004
    Messages:
    1,046
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    South Side Crater, Mars
    damn iam looking for some freeware options across the net,and iam just coming across some sharewares....

    do post back in case you do come acros any freeware..
     
  9. ilugd

    ilugd Beware of the innocent

    Joined:
    Dec 25, 2005
    Messages:
    1,009
    Likes Received:
    3
    Trophy Points:
    0
    for what? mass mailers?
     
  10. ilugd

    ilugd Beware of the innocent

    Joined:
    Dec 25, 2005
    Messages:
    1,009
    Likes Received:
    3
    Trophy Points:
    0
    Aha, i was pounding my brains because i couldn't remember the name of the software which i once used over 2 years ago.

    Just remembered it.

    Try googling for Postcast server. Should work if you want to send mail to a lot of your clients and don't want to deal with a cluttered sentitems folder.
     
  11. OP
    OP
    grinning_devil

    grinning_devil New Member

    Joined:
    Dec 3, 2004
    Messages:
    1,046
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    South Side Crater, Mars
    :( postcast is also a shareware
     
  12. ilugd

    ilugd Beware of the innocent

    Joined:
    Dec 25, 2005
    Messages:
    1,009
    Likes Received:
    3
    Trophy Points:
    0
  13. OP
    OP
    grinning_devil

    grinning_devil New Member

    Joined:
    Dec 3, 2004
    Messages:
    1,046
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    South Side Crater, Mars
    i did saw this free version,but does this support mass mailing??
    i doubt it..

    nywys will download and check!
     
  14. champ_rock

    champ_rock champ_rock

    Joined:
    Jun 15, 2005
    Messages:
    750
    Likes Received:
    1
    Trophy Points:
    0
    Location:
    Somewhere on the earth , near the equator
    what do u do whith this excel thing..... i tried to use it but where do i enter the code
     
  15. ilugd

    ilugd Beware of the innocent

    Joined:
    Dec 25, 2005
    Messages:
    1,009
    Likes Received:
    3
    Trophy Points:
    0
    press alt+[F11]. You will get the vba ide. Create a new form, place a buttoon with the name cmdok and press f7 while the button is selected. You are ready to go.

    by the way, in my excel file the data which i automated was on sheet 2.
     
Thread Status:
Not open for further replies.

Share This Page