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.

Check out this web site:

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

--
Regards,
Tom Ogilvy


"andrewbt" wrote:

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.

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

"Tom Ogilvy" wrote:

Check out this web site:

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

--
Regards,
Tom Ogilvy


"andrewbt" wrote:

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.

Try something like the following:

Sub StartEMail
ThisWorkbook.FollowHyperlink _
?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)


"andrewbt" wrote in message
...
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.