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

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.


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=106491

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

See
http://www.rondebruin.nl/mail/folder1/mail2.htm

and more generally
http://www.rondebruin.nl/sendmail.htm

--
Allllen


"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

As always, I'm very grateful for your (plural) help.

Michael