I think I found an example on how to send the "sheet only" ... It is below. Now my question is, "What can I put in the area for address and subject that will instruct to get the address and subject from specific cells on the next sheet in the workbook?
Private Sub CommandButton1_Click()
ActiveWorkbook.SendMail Recipients:="christopher_hart@hotmail.com", Subject:="ClaimsForm", ReturnReceipt:=True
MsgBox "The Claims Form has been sent", , "Claims Form"
End Sub
Private Sub CommandButton1_Click()
ActiveWorkbook.SendMail Recipients:="christopher_hart@hotmail.com", Subject:="ClaimsForm", ReturnReceipt:=True
MsgBox "The Claims Form has been sent", , "Claims Form"
End Sub