emails through vba

[Executive Vishal]

hi all,

please provide the help

we want to send email through excel <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> - i have a list of 200 emails and i want to send them in a bunch of 15 emails (1 to 15) after 30-50 second again new 15 emails (16 to 30) automatically through vba

Please advice

 

[Michael M]

you have asked a simple question on what may well be a more complicated solution
I don't have Excel at the moment, so can't provide any code...so, have a look here for code provided by Ron to send emails.

https://www.rondebruin.nl/win/s1/outlook/mail.htm


You will also need to use the Application.OnTime method to delay the blocks of data

You will also need to provide more information regarding your data....
which sheet the email addresses are in ??
and which columns ?
What is going in the email title ?
What message is going in the email ?
Are the emails being CC'd ?
Are there any attachments ?

 

[Executive Vishal]

Many Thanks for reply Michaelji,

Please find the more information
in excel sheet1, i have two column data, column A = Name and Column B = email id
no cc or bcc
One attachment (PDF) on desktop and pdf file Name is "Quote"
Subject Line "Quote for Publishing Book"

Text Matter : -

Respected Sir,

Looking forward to pay heed your attention that for last 10 years, I have been contributing my knowledge and writing skills for various publications which are more focused to catch youth and students power for their release which aims to assist & help them in competitive exams.

With regards,

Vikas

 

[Michael M]

Did you visit the link I provided to view the sample codes ??
Why do you need a 50 second delay for every 15 emails ?

 

[Executive Vishal]

Many Thanks for reply Michaelji,

we are checking the link which you have provided to us.

we want to 50 second delay because we don't want to send 50-60 emails at once in that case may be most of the email will be undelivered and we don't want to use other application, we want to use only excel for sending 60-70 emails.

Again Thanks Michaelji,

if you have any code pls provide else checking the web link provided by you.