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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open specific hyperlink (accept) automatically in email with outlook 0
E-mailing a worksheet 1
how do i set up a "send as attachment" shortcut in in a document 1
how do I email an excel file as attachment to a specific address 4
Using "mailto" hyperlink to email the workbook as an attachment 1
Outlook How to create hyperlink with specific page of the pdf attachment in Outlook 2
Sending spreadsheet via email with recipents addy 3
make Hyperlink jump on the top row 2

Back
Top