ExcelBanter - Send an e-mail

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Send an e-mail (https://www.excelbanter.com/excel-discussion-misc-queries/158459-send-e-mail.html)

A User creates a document in excel.
When completed the user should send an e-mail to two approving officers
The document would not be attached
Is there a way to trigger the e-mail when a command button is pushed?
With the proper To, From and Subject Lines?
All the users will be on an internal LOTUS Notes system.

Ron de Bruin has much info on emailing from Excel.

For Lotus Notes info see this page.

http://www.rondebruin.nl/mail/links.htm

Click on the link to Lotus Notes

Gord Dibben MS Excel MVP

On Sun, 16 Sep 2007 04:26:14 -0700, Pa Maher
wrote:

A User creates a document in excel.
When completed the user should send an e-mail to two approving officers
The document would not be attached
Is there a way to trigger the e-mail when a command button is pushed?
With the proper To, From and Subject Lines?
All the users will be on an internal LOTUS Notes system.