Sending Mass Emails on Just Single Click

[E5254730]

Hello Excel Experts,
I have a VBA coded excel sheet which helps me sending emails to my customers by selecting their names from the drop down box (Cell C3).

Let me explain how this actually works :
1. Say if I want to send email to customer A, I'll simply pick customer "A" from the drop down list (C3).
2. I've a button on this sheet. So once customer name is selected. I'll click on the button to send email to customer.
3. Set range i.e. B2 to D12 table gets copied to Outlook email in same format so customer can update any new information in column D.
4. Email will be sent to the Email ID's mentioned in cell C12.

Issue :
I have more near around 1500 customers on my list. So every time I have to select customer name from the drop down list one-by-one. This means to send email to customer B, I'll have to select B from drop down (data table gets populated) and than click on send button. Again to send email to customer C or every customer, I'll have to follow the same steps each and every time.

Requirement :
On just 1 single click on the button, outlook should start sending emails to all customers.
Table data should get copied to email body as per customer name.

Regards,
Prakash

[mikeTRON]

It sounds like you need to learn about LOOPS in VBA.

http://www.excel-easy.com/vba/loop.html
http://www.learn.net.au/vba/vba-loops

[bakerman2]

And where's the code you are using now ?

[E5254730]

Hello,

Please refer to attached XLSM sheet. I've again mentioned the requirement in the same attached sheet.

Regards,

[jaslake]

Hi E5254730

Try the Code in the attached...

[E5254730]

Hi Jaslake,

Wonderful.... that's working like a charm.

Just one single Click and the Outlook starts sending emails to all 1000 customers. Thanks !!!

Regards,
E5254730

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.