I have a cell where anyone can type an email address, and I want that email address to be the one used in this code. Any help will be appreciated.
Sub emailme()
ActiveSheet.Copy
ActiveWorkbook.SendMail "me@myisp.com ", "Hi this is a test"
ActiveWorkbook.Close False
End Sub
"The reward of one duty done is the power to fulfill another"
Jr Clwn
Sub emailme()
ActiveSheet.Copy
ActiveWorkbook.SendMail "me@myisp.com ", "Hi this is a test"
ActiveWorkbook.Close False
End Sub
"The reward of one duty done is the power to fulfill another"
Jr Clwn