Sending email from excel

[matt_decat]

Hi

So I am a total Noob at VBA but can sorta understand the basics and have been able to merge VBAs in the past to get what i require but am failing miserably now.

I have a VBA which will send a range to outlook, but then you have to manually type in the subject and recipients. The VBA I have at the moment is the only one that I can find that will send a range that includes a table into the body of the email.

Please Login or Register  to view this content.

Can someone help with automatically entering the To list from a range of cells that i have as well as the subject line and then sending the email.

P.S i have be on Ron DeBruins site but haven't been able to merge the above code with any of this codes.

[bakerman2]

Do you want to send it to one or several persons at the same time?
In which range are mailaddresses located?
Try this for one address in activesheet range A1

Please Login or Register  to view this content.

[matt_decat]

Thanks

Works great. I thought I tried something like that myself but i didn't work so I no doubt had an error of some sort in there.

[bakerman2]

You're welcome and thanks for rep points.