Send a single worksheet via Outlook

  • Thread starter Thread starter Michael Lanier
  • Start date Start date
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
 
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
 
Back
Top