Need to auto send an email in excel

[scthread]

I have a rather complex email being created in excel, currently it works fine but I want to skip the step where I have to click send... I want excel to generate the emai (code already works) and then rather than have to click the send button - i just want it to go. Reason? Well I am needing to create and send the email over 100 times each time i create the email it goes to a new person, I cannot do a mass email for this project... and my fingers are getting sore! I want to do it with the click of a single button... I am thinking there is something i need to put at the end when it displays the email - so that it doesn't display it per say... but sends it.

 

[Logit]

.
Change the line

.Display

to

.Send

 

[scthread]

.
Change the line

.Display

to

.Send

Thank you!

 

[Logit]

.
You are welcome.