The code examples on this page are created by Excel MVP Dennis Wallentin but are not on his site anymore.
But Dennis allow me to publish it on my site for all the Excel/ Lotus Notes users in the world.

If you use Outlook, Oulook Express, Windows Mail or Windows Live Mail visit this page for examples:
http://www.rondebruin.nl/sendmail.htm


Lotus Notes example pages

Lotus Notes: Save and Remove attachments

Lotus Notes: Save attachments and delete the associated e-mails

Lotus Notes: Retrieve e-mailaddresses from a Notes database

Lotus Notes: Send a workbook as attachment to a created e-mail

Lotus Notes: Send data from a range as part of an e-mail's body

Lotus Notes: Send formatted data from a range or chart as part of an e-mail's body

Lotus Notes: Send the active sheet as an attachment

Lotus Notes: Send worksheets to several recipients