Sending automated emails from excel using VBA

Hey all,

So i am trying to send automatic emails using excel source information and VBA code. However I cannot seem to put it together. I searched this forum and found this http://www.excelforum.com/excel-prog...-in-range.html

This kinda works, BUT for every line - which is not desirable. I do not want it to send email for every line i want to summarize it by email but - and send only like 15 emails instead of i.e 65 emails for every line.

How can it be done, please help.

My table looks like this:

Period	Number	Provider	Service	Count	Duration	Total	Email
201504	31987	ETV	Phone	12	23	23432	[email protected]
201504	31987	ETV	Phone	12	23	23432	[email protected]
201504	31987	STV	Phone	12	23	23432	[email protected]
201504	31987	STV	Phone	12	23	23432	[email protected]

And code from the other thread looks like this.

Please Login or Register  to view this content.

End product should look like this:

message TO [email protected]

Hello,

Here is the report:

Period	Number	Provider	Count	Duration
201504	31987	STV	12	23
201504	31987	STV	12	23

Best,
Annux

Try this...

Please Login or Register  to view this content.