I have a range on a worksheet that will be getting emailed to the same
company frequently. I currently have the following code to copy the range so
the user can just paste it into the email and just hit "send":

ThisWorkbook.Worksheets("Schedule Sheet").Range("LMPLAN").Copy

Upon returning to the worksheet, I would like the blinking copy command to
automatically go away.

I'm thinking I need to write something like this:

If ThisWorkbook.activate = True,
then Application.CutCopyMode = False

But that evidentally isn't the proper code. What would be the proper way to
write this code?

Also, is there any way to add code to automatically open our email (We use
Lotus Notes) so the user can just paste the data?

Thanks!!

--
Patti