change email code to use with range instead of sheet

[dotxls]

Good Evening,

Could I please ask for some help. I have used ZVI's code from another forum which works almost perfectly, but I would like it to email a range B2:O200 instead of the complete sheet

I am not sure how to modify my existing code to suit the range

any help would be greatly appreciated

Please Login or Register  to view this content.

[tim201110]

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[dotxls]

Hi tim,

that is perfect many thanks for your time

if I wanted to add more .CC to the email do I have to add more lines or can I use the same line with multiple emails addresses

Also is it possiblr to remove the message box saying that email has been sent

Thanks again

[tim201110]

you can use the same line with multiple emails addresses
comment unneeded lines out