email a clipboard copy as imbedded in body

[oletrol]

Hi I have been using the macro below to send plain Emails through Excel2003 for quite a while now and it works very quick and almost every time.

But I would now like to select an area on a worksheet ^c to copy it and ^V to paste it directly to the body of the email.

The reason for this is there are buttons and all kinds of underlying macros if I copy it to another book and send it that way all of that stuff will go to.
Also I have a lot of formatting on this page that won’t go with the email if I send it this way. I want the receiver to see the formatting but not the controls or macros.

Does anyone have an idea of how I can insert a clipboard copy of the area I want to go directly in to the Hyperlink in place of the Msg in the body or as the msg
I’ve tried msg= ddd.jpg, msg= ^v, msg=SendKeys "^{v}"

I also tried also tried this line of code HLink = HLink & "body=" & SendKeys "^{v}" nothing has worked.

I have used the send a single sheet copy file method but it always brings up the warning
“A program is trying to send an email and it has to wait for an answer. If someone can tell me the code to shut of this warning I would just do that.
Application.DisplayAlerts = False does not work.
Using this macro put your email.address in [q1].

Help !!!! Surely there has to be a way for one or the other to be done.
Preferably making the one below work would be the best for me.

Please Login or Register  to view this content.

Any and All help would be appreciated

Gene Mills

[Paul]

Hi Gene,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Please also post your question in the proper forum. I've moved this thread to the Programming forum, rather than the Worksheet Functions forum.

Thanks!