I'm new to VBA and pretty much making it up as I go along.
At the moment I have the following line of code:
ActiveWorkbook.SendMail Recipients:="godross22@hotmail.com", Subject:=Range("C4") & " TELEPHONE REFERRAL " & Range("C20")
It's working fine except it sends the entire document whereas the only sheet that needs to be sent is the current one (named "TELEPHONE REFFERAL FORM"). The additional sheets tabs are surplus and fairly bulky so they take up precious space in the recipient's inbox.
I've tried changing "ActiveWorkbook" to "ActiveSheet" and "ActiveWorksheet" but all I've got from that are errors, can anyone help?
At the moment I have the following line of code:
ActiveWorkbook.SendMail Recipients:="godross22@hotmail.com", Subject:=Range("C4") & " TELEPHONE REFERRAL " & Range("C20")
It's working fine except it sends the entire document whereas the only sheet that needs to be sent is the current one (named "TELEPHONE REFFERAL FORM"). The additional sheets tabs are surplus and fairly bulky so they take up precious space in the recipient's inbox.
I've tried changing "ActiveWorkbook" to "ActiveSheet" and "ActiveWorksheet" but all I've got from that are errors, can anyone help?