Kapalı

Send batch emails from Excel Template using VBA

Scope:

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

Requirements:

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)

Notes:

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

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

Proje NO: #16343020

Bu iş için 13 freelancer ortalamada $69 teklif veriyor

avinav606lx

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
(156 Değerlendirme)
6.5
expertatwork

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%
(195 Değerlendirme)
6.1
whitehorsetechn

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%
(10 Değerlendirme)
4.5
periyannas

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%
(16 Değerlendirme)
4.1
liangjongai

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
(4 Değerlendirme)
3.7
Overseashelp

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)
3.3
sajidkhan45

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%
(5 Değerlendirme)
3.0
hsingla85

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
(4 Değerlendirme)
2.7
imranrazawi

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

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

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)
2.6
sloker18

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
(3 Değerlendirme)
2.2
henrymassage

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)
0.0
ethieljymn01

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)
0.0