send excel sheet to email recipient as hyperlink

[Cyndi]

Hi,

My working files always comes with photo and thus creates a big file. So
instead of sending it as "Send to Email recipient (as Attachment)", is there
a way I can send it as hyperlink?

I would like to do this while I'm on my Excel sheet and not in the microsoft
outlook window.

Experts, pls. help!
CynDi

 

[HelpExcel.com]

Cyndi,

You would have to save it to a web-server in order to send a hyperlink.

 

[PJFry]

Cyndi,

Do you want to send a hyperlink so someone who shares a server with you, or
a hyperlink so anyone, anywhere can open it?

Because of the file size issue you talk about, I always send hyperlinks,
something like:
Q:\Data\Finance\ThisBook.xlsx

Is that what you are looking to do?

 

[Sri]

Cyndi,

Do you want to send a hyperlink so someone who shares a server with you, or
a hyperlink so anyone, anywhere can open it?

Because of the file size issue you talk about, I always send hyperlinks,
something like:
Q:\Data\Finance\ThisBook.xlsx

Is that what you are looking to do?
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.








- Show quoted text -

check the below article to get your task done. just change

attach.Add "" & Cells(i, 6) & "" to mail.Body = Cells(i, 6) in the
code to send the attachment as a hyperlink instead of attachment. Hope
this helps

http://funwithexcel.blogspot.com/2009/05/macro-to-send-multiple-emails-along.html