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: 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, transfer data excel word using vba, install excel add using vba, export data webpage excel sheet using vba

About the Employer:
( 1 review ) Auckland, New Zealand

Project ID: #16343020

13 freelancers are bidding on average $69 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
(156 Reviews)

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

$51 NZD in 2 days
(195 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
(10 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
(16 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
(4 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)

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
(5 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
(4 Reviews)

I can develop Excel macro which send email with outlook using VBA. I have developed number of different database and office solutions.

$28 NZD in 1 day
(2 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)

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
(3 Reviews)

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)