Sent to as attachment command

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??
 
R

Ron de Bruin

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
 
Top