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

Skills: Data Processing, Excel, Microsoft Outlook, Visual Basic, Visual Basic for Apps

See more: 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

About the Employer:
( 4 reviews ) Auckland, New Zealand

Project ID: #16343020

12 freelancers are bidding on average $73 for this job


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

$144 NZD in 1 day
(176 Reviews)

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

$51 NZD in 2 days
(200 Reviews)

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.

$100 NZD in 2 days
(62 Reviews)

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

$28 NZD in 1 day
(8 Reviews)

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 More

$160 NZD in 2 days
(13 Reviews)

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

$100 NZD in 3 days
(36 Reviews)

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 More

$25 NZD in 1 day
(45 Reviews)

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.

$61 NZD in 1 day
(3 Reviews)

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 More

$56 NZD in 1 day
(6 Reviews)

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 More

$28 NZD in 1 day
(1 Review)

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 More

$88 NZD in 1 day
(0 Reviews)

I can be help

$30 NZD in 5 days
(0 Reviews)