View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Accessing the Mail Recipient function


Hi Jordan,
Ron de Bruin has pages on Sending Mail
he has addins (Sendmail addins) and macros the macros are a little harder to find as such (Excel Tips)
http://www.rondebruin.nl/

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jordan" wrote in message ...
Hello,

In my, and I assume most everyone else's, SendTo folder there is an icon
that is labeled "Mail Recipient" which it says is type MAPIMail
How can I access this function from vb and is there a way to modify the
function. I couldn't figure out what to open it with. If I can I would like
to modify the SendTo file function to send the mail recipient a shortcut to
the document, which sits on a public drive, rather than the actual document.

Thank you for any help,
jordan