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

On Sun, 14 Jun 2009 08:37:33 -0700 (PDT), Michael Lanier
wrote:

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