Macro To Copy from Excel and Paste into Outlook

[dwc142]

Is it possible to create a Macro that will copy certain things from an Excel workbook, and paste them as Pictures into a new outlook E-mail? I know it's a stretch but I was just curious if it is possible to create such a macro that goes between both applications. Thanks for your help!

Regards,
Dave

 

[Cbrine]

dwc142,
Yes.

 

[Cbrine]

Just to expand on that a little.

You would need to either early bind or late bind to the outlook object. You could than create a new email, and copy the information from excel into the outlook message. The only problem I could see, is that if you try and send the mail, you are going to fall prey to Outlooks security restrictions, and be prompted with the "outside program trying to access email" message.

HTH
Cal

 

[dwc142]

Just to expand on that a little.

You would need to either early bind or late bind to the outlook object. You could than create a new email, and copy the information from excel into the outlook message. The only problem I could see, is that if you try and send the mail, you are going to fall prey to Outlooks security restrictions, and be prompted with the "outside program trying to access email" message.

HTH
Cal

Those Outlook security Restrictions may be the end to this idea......My company has me beyond LOCKED down!

But if I could get passed that, how do you go about binding the outlook object?

Thanks for your help!

Regards,
Dave

 

[Cbrine]

That's where it becomes a little gray...The security options are in Outlook, so you will hit them. There is a custom library that goes around these called "Redemption", but I was never able to get it to work for me correctly. Once you get into custom libraries, you are talking fairly advanced stuff. As far as binding to outlook, you will need to do this.
1. Open the vbe editor by press Alt-F11.
2. Select Tools...References from the menu.
3. Find Microsoft Outlook ##.# Object Library, and check it. (this is late binding)

You will need to do a little research on the MSDN web site to find out how to use this library as well.

HTH
Cal

PS-Another Option is using SMTP mail, but you will need an SMTP server to use this option. Which IT is most likely not going to give you

 

[dwc142]

PS-Another Option is using SMTP mail, but you will need an SMTP server to use this option. Which IT is most likely not going to give you

Hehe...Yea, I've already been denied that access a couple of times!

I even got in once and then all hell broke loose!

Thanks for all your help!

Best Regards,
Dave