Excel VBA force new email window to get focus.

[CO#]

Hi all,
I am trying to send an email from a userform in excel. It works on my computer, but on some of my user's computers the new email does not get focus so when I SendKeys to paste the copied data into the email it doesn't get pasted. I am showing the email because the user may need to add attachments before sending.
1) My main question is: How can I force the newly created email to get system focus so that the paste works?
2) Side question: Is there a way I can paste the range into the email without using sendkeys?

Edit: I wanted to note that I added the doevents because I thought that that would allow the system to process things so that the paste would work.

Please Login or Register  to view this content.

____________________________________________________
Please pretend that there is a witty and deep signature line here.

[nathansav]

create the message using code using .body, you can copy the range as image, save it locally, use HTMLbody to add an image using <img> or just itterate the data building the message.

[CO#]

Nathansav,
If I save it as an image wouldn't that prevent users from pasting the emailed data into other excel files? I also really need to get system focus on the new email otherwise the users will have to hunt for it to send it which would decrease the probablility of the message getting sent.