I have a routine where I am copying from a hidden worksheet, and pasting into
an email message. I would like to clear the clipboard after the email
message is sent.
I have tried this by using the Application.CutCopyMode = False after calling
the sub routine which handles the Outlook object. So far, everything I have
tried, clears the clipboard before Outlook has a chance to load the email
message. Does anyone have a method of doing this?

Steve

Steve,

Set the body of the email message to the value of the cells of interest,
without copying.

See

http://www.rondebruin.nl/sendmail.htm

for examples, depending on how you want to do it.

HTH,
Bernie
MS Excel MVP


"Steve" <(E-Mail Removed)> wrote in message
news:0BBDF7FE-AA44-472D-9F2F-(E-Mail Removed)...
>I have a routine where I am copying from a hidden worksheet, and pasting
>into
> an email message. I would like to clear the clipboard after the email
> message is sent.
> I have tried this by using the Application.CutCopyMode = False after
> calling
> the sub routine which handles the Outlook object. So far, everything I
> have
> tried, clears the clipboard before Outlook has a chance to load the email
> message. Does anyone have a method of doing this?
>
> Steve