Using VBA to send Email by selecting email from a cell within a worksheet

Hi,

I am currently using the following code to send my excel workbook in an email.

*ActiveWorkbook.SendMail Recipients:="[email protected]"

But I have to write an email address in the code. I would like it to be picked up from a cell within the worksheet. I have also tried

*ActiveWorkbook.SendMail Recipients:=range("A1").select (This cell contains the email address where the email needs to go) but it is not working. Can I get some suggestions on how to make it work please so that I enter an email address in the sheet and use the macro to pick that email address automatically.

I will appreciate your help.

Regards,