Copy/Paste into Outlook

**rivera82falcon** · 02-07-2012, 03:27 PM

I'm new to coding in excel although I find it very interesting and fun!

What I am attempting to accomplish is copying a select amount of cells in a worksheet and paste into an email with a button click. As of now, with help from here and online browsing, I'm able to get the code to copy the cells and open an email session (outlook) with fields filled out. My problem now is that I can't get the image to paste into the email unless I press CTRL + V.

What am I missing? This is what I have:

Please Login or Register  to view this content.

**rivera82falcon** · 02-14-2012, 02:28 PM

Anyone have an idea? I'm still playing around with this and cannot get it to work for the life of me. Thanks!

EDIT::

Adding Application.SendKeys "(^v)" doesn't do anything... =(

**rivera82falcon** · 02-14-2012, 08:20 PM

Yes, I know that:

Please Login or Register  to view this content.

exists...but once emailed, you cannot read the email on a BlackBerry device because any cell that has boarders around it is removed, all the text is joined together with no spacing or too much spacing. That's why I'm using:

Please Login or Register  to view this content.

to take a snapshot of the cells I want. I can manually paste it into the body however we have people that don't know how to paste and want this to happen automatically. Please help?

**jaslake** · 02-24-2012, 03:12 PM

Hi rivera82falcon
Take a look at this link...you can download a sample workbook that has code to do as you require
http://www.xcelfiles.com/EmailImg.html