Application.CutCopyMode

[Guest]

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

 

[Bernie Deitrick]

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