Application.CutCopyMode
 

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

Application.CutCopyMode
 

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" wrote in message
...
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