Send email automatically through excel with attachement and picture

**yorkshirewhite** · 03-24-2011, 08:31 AM

Hi

Im wondering if anyone can help me. Ive got some code that creates an attachement and emails it out for me through lotus notes. The only issue I have is i want to copy some cells on an excel worksheet and paste it into the body of the email as a picture, but for the life of me i cant get the picture into the email. Here is the code im currently using which works for attaching and sending the email with lotus notes:

Please Login or Register  to view this content.

**pike** · 03-25-2011, 01:16 AM

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

**yorkshirewhite** · 03-31-2011, 05:47 AM

Hi i've made the adjustment, however does anyone have a solution to the problem?

**yorkshirewhite** · 05-20-2011, 05:09 AM

anyone please?

**snb** · 05-20-2011, 08:02 AM

Lotus Notes is not a MS Office program.
Maybe you should look for another embedded Object, like

Please Login or Register  to view this content.

I do not exclude the possibility that another parameter than 1454 stands for a picture...
You can check that in your VBEditor, using F2.

**yorkshirewhite** · 05-20-2011, 12:16 PM

Would that not just attach a picture as a file?. Ideally im looking to attach a cell reference i.e A1:B2 as a picture into the body of my frame so its viewable on a blackberry without anyone having to open an attachment.