Hi John

I asked a similar question recently in regards to being able to send
email when not using Outlook.

Ron de Bruin kindly responded:

CDO is a option maybe for you
http://www.rondebruin.nl/cdo.htm

I have not had time to check it out but it may cover what you are
looking for.

Thanks

Andy

John wrote:
Does anyone know how to send an Excel Workbook as an attachment in a email
from a button on the Excel workbook. We use Lotus notes as our email so if
anyone has done something like this and can point me in the right direction I
would greatly appreciate it. If there is anyway to save the email in the
person's mailbox that would be the topping on the cake also.

Thanks in advance,
John