Sent to as attachment command

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I was wondering if there is a way to set up a hyperlink
that when clicked sends the workbook as an attachment to
the person specified by the hyperlink??
 
Hi Tom

A hyperlink can't do this as far as I know
But you can use a macro that will send it
to the address in the activecell

Sub Mail_workbook()
If ActiveCell.Value Like "*@*" Then
ActiveWorkbook.SendMail ActiveCell.Value, _
"This is the Subject line"
End If
End Sub

See for more mail examples
http://www.rondebruin.nl/sendmail.htm
 
Back
Top