Thread: Add hyperlink to body of email thru Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MAYDAY[_5_] MAYDAY[_5_] is offline
external usenet poster
  
Posts: 1
Default Add hyperlink to body of email thru Excel

Hi,

I have a macro that saves an excel file and sends it to variou
recipients. How would I add a hyperlink to the body of the emai
instead of the actual file itself?


ActiveWorkbook.SendMail Recipients:=Array("Body, Ann E"), _
Subject:="Test Hyperlink"


Thanks in advance

--
MAYDA
-----------------------------------------------------------------------
MAYDAY's Profile: http://www.excelforum.com/member.php...fo&userid=1354
View this thread: http://www.excelforum.com/showthread.php?threadid=38524

Reply With QuoteReply With Quote