e-mail macro

[Guest]

pls help, is there any way to make a macro in excel open Microsoft Outlook
and assign it to a button? Ideally i would like a button that opens outlook
and types in the same e-mail address every time. Is this possible? any help
greatly appreciated.

 

[Guest]

Check out this web site:

http://www.rondebruin.nl/sendmail.htm

 

[Chip Pearson]

Try something like the following:

Sub StartEMail
ThisWorkbook.FollowHyperlink _
Address:="mailto:[email protected]?subject=This is a test"
End Sub

Change the recipient address and subject as desired. Assign the procedure
StartEMail to a button on the sheet.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Guest]

Thank you Tom, i think it is safe to classify you in the category earmarked
'Ledgends'. You have saved my butt.