Use mail addresses in cells.

[ANDREAAS]

Hi Guys

I am trying to adapt some code that i got off Ron de Bruin's site. It activates a sheet based on option button selection and then has to mail to the recipient who's e-mail addresses are entered into cells in the sheet called start, also it needs to copy only values and not the formulas in the selected sheet, but no matter what i try, it does not mail to the recipients. Code below.....

Please Login or Register  to view this content.

[gmr4evr1]

Try adding

Please Login or Register  to view this content.

to your Dim statements
Then add

Please Login or Register  to view this content.

After your Set statements then change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[ANDREAAS]

you rock man. thank you and thanks for the quick response.

[gmr4evr1]

No problem, glad it worked for you.
Thank you for the feedback and rep!