Send a single worksheet via Outlook

M

Michael Lanier

I'm wanting to send a single worksheet via Outlook based on the
following parameters:

1. Upon entry of an email address in a merged cell to trigger the
event
2. Not to be resent unless the email address is deleted and reentered
in the cell
3. The worksheet is to be sent as an attachment

Thanks in advance.

Michael
 
R

royUK

You can find all the code you need for the amail on Ron De Bruin's web
site. The email woud be triggered by the worksheet cahnge event,
although you will make this more difficult by choosing to use Merged
Cells. In a range of merged cells, the only cell that can contain a
value is the top left.
 
G

Gord Dibben

Be aware that a worksheet cannot be sent as an attachment.

The sheet must be copied to a new workbook for attaching.

Ron's code or sendmail add-in looks after that step.


Gord Dibben MS Excel MVP
 
Top