How to send an email via Outlook Express?

[Lisetsky Mykola]

Hello!
I work with Excel and want to send an e-mail message. My mail client is
Outlook Express. I'd like to prepare a letter (to create its body, to select
reciepients, to form a subject line and attachements).
Give me an example of solving such a task, please.
Thank you.

 

[Tushar Mehta]

Haven't tested the foll. w/Outlook Express -- and don't intend changing
my default mail client to do so {grin} -- but, check out the Workbook
object's SendMail method. It states "Sends the workbook by using the
installed mail system." So, it *should* work.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Lisetsky Mykola]

check out the Workbook object's SendMail method.
It states "Sends the workbook by using the installed mail system." So, it

*should* work.

Thanks, but this method sends the currently opened workbook and my task
is to send a simple text (not the workbook) with some files as attachments.
Workbook's SendMail doesn't have parameter(s) that specify attachment(s) I
need.
Sorry.