Closed Thread
Results 1 to 4 of 4

send bulk emails by vba excel

  1. #1
    Registered User
    Join Date
    10-08-2023
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    35

    send bulk emails by vba excel

    Hello brothers,

    I need a VBA expert who can support me with sending bulk mail from Excel to Outlook version 365,

    Attached Excel sheet as an example, you will find two parties
    The first part
    Column A: All subject line
    Column B: All body Email Message
    Column C: All Email recipient's
    .............................................................
    the second part is as below :
    Column E: Contains the outlook profile name
    Column F: All sender email accounts
    Column G: how many emails the Sender's Email Address Outlook will send to email recipients per hour
    Colum H: Sender's Email Address outlook accounts limitation { total emails that one sender email account will be sent emails from the whole of email list recipient }
    .............................................................

    What do I need to function running?
    I want Excel VBA run to send emails according to subject lines and message body lines to email recipients according A2 to b2 to c2. the first Part
    the urgent point in the second part is Changing Or rotating the Sender's Email Address according to the limitation {Column H}with how many emails will be sent by the sender's email address per Hour (G)

    I waiting for your feedback

    Regards
    Last edited by AliGW; 10-28-2023 at 09:40 AM. Reason: Workbook removed.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,879

    Re: send bulk emails by vba excel

    I have removed the workbook for security reasons. Please replace it with one that has been DESENSITISED (that is, does NOT contain ANY real contact details).

    Please do not post sensitive data on a public forum.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    10-08-2023
    Location
    egypt
    MS-Off Ver
    2010
    Posts
    35

    Re: send bulk emails by vba excel

    ok i attached another file without email contact
    Attached Files Attached Files

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,879

    Re: send bulk emails by vba excel

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #2 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...ion-365-a.html

    Thread closed.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Please help me code on VBA to send bulk whatsapp messages & emails
    By painfullystoic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2021, 02:35 PM
  2. Excel VBA Bulk emails with .oft template taken from a cell value
    By ClaudiaRovastino in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2020, 08:05 AM
  3. [SOLVED] Send Bulk Emails
    By tejboyd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-30-2016, 12:45 AM
  4. Excel vba to auto-send customer emails (duplicate emails issue)
    By nadz84 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-29-2015, 10:08 AM
  5. [SOLVED] Bulk emails send use outlook & excel coding macro
    By sonu_kumar444 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 12-26-2012, 08:06 AM
  6. Sending macro emails using excel: Send emails with their passwords.
    By loveisblind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 03:16 PM
  7. Replies: 0
    Last Post: 12-15-2005, 09:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1