Send batch emails from Excel Template using VBA


Create VBA to send individual emails out to different receipients based from the excel template provided. There are 2 tabs (Customer & Supplier), each tab requires to be sent by different email accounts in Outlook


1 Both Customer & Supplier tabs are similar and requirements are the same

2 Emails should be sent individually to each recipient using the columns contained in each spreadsheet

3 1 button to send all emails in each tab (i.e. tabs customer and supplier should be used and sent separately)

4 When button is clicked there should be a confirmation message if wish to send emails to avoid accidently clicking the button

5 Once email is sent, there should be a confirmation for example a 'tick' or 'sent' text populated in a column (I)


1 My outlook has multiple email accounts. I.e. I need emails from the customer tab to be sent using my account A, and supplier emails to be sent by account B.

How can this be achieved? - can the selected account be based of a cell in the spreadsheets? See below images

Beceriler: Veri İşleme, Excel, Microsoft Outlook, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: sending email to a list of recipients using excel and outlook, send multiple emails from excel list, how to send multiple emails in outlook with different attachments, send multiple emails from excel list vba, excel vba send email to multiple recipients, excel macro send email to address in cell, vba code to send email from excel to multiple recipients with attachment, how to send multiple emails from excel spreadsheet, scrubbing excel file using vba, send bulk emails excel spreadsheet, excel treemap using vba, excel dashboard using vba, import excel access using vba, send 10000 emails excel, using excel data send blast emails, send data excel iseries as400 using vba, display data values excel chart using vba macros, vbaexcel connecting excel access using vba private, send automated emails excel vba outlook, send bulk emails access database using java jsp

İşveren Hakkında:
( 4 değerlendirme ) Auckland, New Zealand

Proje NO: #16343020

Bu iş için 12 freelancer ortalamada $73 teklif veriyor


Hi Mate, I have created a macro to do something similar to this, I can show that as demo if you’re interested. Ping me to discuss more. Thanks Aman Jha

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(176 Değerlendirme)

Yes, I can develop this macro to switch between Outlook accounts. Please reply, thank you!

in %bids___i_period_sub_35% gün içinde51%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(200 Değerlendirme)

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(62 Değerlendirme)

Hi! I'm interesting your project very well. I am mastering excel and vba. And also I have many experience and good skill about web development. Let's go ahead with me

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(8 Değerlendirme)

Greeting, I have understood your Send batch emails from Excel Template using VBA task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Daha Fazla

in %bids___i_period_sub_35% gün içinde160%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)

Hey, It looks like an interesting project and i would love to take it. You can go through my reviews so that you could be confident about your faith in my abilities. Hope to chat with you soon Sajid

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(36 Değerlendirme)

I have read your requirement that you want to have a button to send email to all recipients listed, using multiple outlook account, I am proficient in using Excel VBA macros, your proposal can be done easily and quickl Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(45 Değerlendirme)

hello, i am interested in your project. i'd love to help you create the macro to send emails on both tabs. i will need some more details over chat. waiting to hear from you, thank you.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(3 Değerlendirme)

Hi, I am a MBA from one of the top B-schools in India. In terms of professional experience, I have worked in consulting and banking domain in various roles and responsibilities. I have been freelancing from the past Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(6 Değerlendirme)

Hi there, I consider myself to be the perfect choice for your job post regarding Data Processing, Excel, Microsoft Outlook, Visual Basic, Visual Basic for Apps . Do you want to know the reason why? Hire me and you’ll Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(1 Yorum)

Your requirements seem clear. I assume that you wish to keep adding new customers and suppliers to the bottom of each table? So once you have sent a email to the first 10 customers and Column "I" has the word "Sent Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% NZD
(0 Değerlendirme)

I can be help

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)