Excel Data to Outlook Message Body

Good Evening,

I am using the code below to send my data from excel to outlook. It works but I would like to add my To: line from Range K2:K50 please.

This Code is originally from Ron de Bruin Website

Please Login or Register  to view this content.

Thanks,

Gerad

Update I can get the To = "[email protected]" to equal k2 and k3 with:

Please Login or Register  to view this content.

Is there a faster way to do a range of cells since I want a range of K2 to K51?

Thanks Gerad

Thank You!

Gerad