Send sheet as email ... with pictures

[beeawwb]

Hi all,

Have done a number of searches on how to do this, and keep drawing blanks. Thought I'd come to my favourite Excel gurus to see if something can be worked out.

I'm designing a form in Excel where my users will fill in the boxes, etc, calculations will be performed and when everything is done, click a button at the bottom of the form and it sends itself as an email. That part's easy, no problems there.

The problem is, I want to include a picture (logo) so it appears to be a letterhead on the form, just for a bit of extra credibility when emailing the form.

I can't find any code that will allow me to do this. Closest I came was some code from Ron deBruin, using the MailEnvelope commands, but while the site suggests it should send pictures, they weren't included.

Has anybody come up with any way to include pictures when sending?

Thanks in advance,
Bob

[Leith Ross]

Hello beeawwb,

To include pictures in your email requires using Outlook and converting your email automatically into an HTML format. All of which can be done using late binding from Excel to the Outlook application. Because you are sending an HTML formatted email, the recipient's email program must also be capable of receiving HTML. Other potential problems are that your email may be blocked or quarantined by the spam blocker or anti-virus program of the one receving your email. The basic HTML tag that needs to be included in the body of the email is ...

   <img src=” file location and name”>

This can be added at the start or end of the email body (easy) or somewhere in the text of the message body (not so easy). I have never written coded for this, but that has never stopped me before. If someone else doesn't provided a solution in a reasonable amount of time, I will work on this for you.

Sincerely,
Leith Ross

[beeawwb]

Hi Leith,

As it happens, I just worked out another way which has seemed to work. I only have the 1 picture, so I deleted it and tried creating it again using Insert->Object->Create from File, and selecting my bmp. That sends fine in the email.

That said... I've run into another problem, which will probably be the subject of another thread, just to keep the discussion seperate.