Macro Sending an Email from excel with an object in the body.

[Mhay5656]

Hi

I need an Macro that I can send an email from excel and paste an object in the body.

I want it to the following
copy and a range of cells as an object or picture.
Open MS Outlook
Fill in Recipient
Subject - need to lookup a cell for the details
Paste Object in the body
Send email
Many thanks

[Logit]

.
Paste this into a routine module :

Please Login or Register  to view this content.

[Mhay5656]

Hi

Thank you very much for writing the macro for me, the email sent perfectly but unfortunately without the picture in the body.

At the email - end sub - there was a line then (separator) then after the separator was - Function, is the macros suppose to show as 2 separate and/or is there I way I need to join them ?

I only changed the range in the function macro, should I have changed more details.

I made a SnagIt of the macro but don't know how to attached it to this thread, I clicked on above but it does nothing

sorry I'm new to this

[bakerman2]

Try yhis way.
Just change red text to correct sheet and Range.

Please Login or Register  to view this content.

[Mhay5656]

Hi,

When I run the macro I get an error saying "Microsoft Excel has stopped working" - Restart the program.
How do I attach a copy of what I have entered for you to look at?
Many thanks

[bakerman2]

Click the Go Advanced button under the Quick Reply window.
Scroll down to Manage Attachments.
Click Choose File and select the file you want to attach.
Click Upload and Close Window.
Submit Reply.

[Logit]

.
The first macros I posted contain a SUB and a Function. They look like two separate macros. Both must be in the same routine module. You can download the attached file in the first post and study the code there.

Here is another project that allows you to paste an image into the email body :

Please Login or Register  to view this content.

Because there is an image associated with this project, I zipped everything together. You'll need to change the paths in the code to suit your computer.

[Mhay5656]

Hi,

Please see attached.

[Logit]

Mhay5656

Your project looks really good. Was there something else you needed for it or are you done ?

[Mhay5656]

Hi
I cant get it to work

[Logit]

.
Works here ...

Image2.jpg

[bakerman2]

Works just fine on my end too.

[Mhay5656]

Thank you.

[Mhay5656]

Hi again
This work really well and thank you, one more question is there a way you can print the email?