Adding an image signature to an Email generated from VBA

Raz Boyarski

unread,

Feb 20, 2010, 5:37:52 AM2/20/10

to

Hi,

I have a project I'm working on which sends emails automatically from excel
using VBA.
The problem is that the mails generated doesn't include my signature.

Until today I was doing that using a pattern in html with a TEXT signature
I included.

Now I want to change that to include the default signature I have in outlook.
the problem is that signature is a picture so it can't be converted to html.

I want to try and solve the problem without any security warnings poping
out and stuff.
I want to keep using patterns of mails and if possible, to include my picture-signature
in those mails.

Is something like this possible?

thanks.

joel

unread,

Feb 20, 2010, 7:49:01 AM2/20/10

to

See ron Debruin's webpage

'Insert Outlook Signature in mail'
(http://www.rondebruin.nl/mail/folder3/signature.htm)

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=181074

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

Raz Boyarski

unread,

Feb 20, 2010, 8:13:40 AM2/20/10

to

Already read this page.
He doesnt show a solution to an image signature.
only HTML.

> See ron Debruin's webpage
>
> 'Insert Outlook Signature in mail'
> (http://www.rondebruin.nl/mail/folder3/signature.htm)

joel

unread,

Feb 20, 2010, 8:56:50 AM2/20/10

to

To put images into e-mail you have to save them as an HTML file and
then insert the HTML file into the e-mail. Ron's example 2 show how to
add the HTML file. You simple have to create the HTML file with the
signature.

A simple method of doing this is to create a word document and paste
the signature into the word document and then save the word document as
HTML. Then whenever you need to add the signature reference the HTML
file that you saved.

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=181074

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

Raz Boyarski

unread,

Feb 20, 2010, 10:40:38 AM2/20/10

to

Hi,

I already know that.
Did you try to do it?

The HTML file will include a path to the image and an image tag to show it
in the HTML page.
When you take the html code and put it as the HTMLBODY of the mail item,
the image will not be shown since the path to the image is not the same in
the HTML file and in the HTMLBody of the mail item.

I see a big red X shown instead of the picture...

> To put images into e-mail you have to save them as an HTML file and
> then insert the HTML file into the e-mail. Ron's example 2 show how
> to add the HTML file. You simple have to create the HTML file with
> the signature.
>
> A simple method of doing this is to create a word document and paste
> the signature into the word document and then save the word document
> as HTML. Then whenever you need to add the signature reference the
> HTML file that you saved.
>

Ron de Bruin

unread,

Feb 20, 2010, 1:28:30 PM2/20/10

to

Hi Raz

I never use/test it but I think I try to link to a picture on the web

StrBody = "<table><td valign=""top""><img src=""http://www.lalala.com/header.png"" alt=""My logo"" " & _
"width=""600"" height=""120"" hspace=""10"" vspace=""10"" align=""left"" border=""0"" /></td>" & _
"<tr></table>"

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Raz Boyarski" <spo...@gmail.com> wrote in message news:9289ea6746cb8...@nntp.aioe.org...

joel

unread,

Feb 20, 2010, 2:48:59 PM2/20/10

to

Ron: I don't think we need to link the picture into a webpage, instead
we need to put the picture into a HTML file so the image can be seen by
the receiver of the e-mail.

I can put a picture into a webpage and save the page as an XMLT a get
the the picture saved into the file (not a link). but haven't found the
trick in to getting the picture into an html. Can you read an XMLT into
an email?

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=181074

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

Ron de Bruin

unread,

Feb 20, 2010, 4:37:03 PM2/20/10

to

Hi Joel

I never test it but I will do it this week and post back here.
If I create mail I like to link to pictures that are online(to keep the mail small)

You here from me

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"joel" <joel....@thecodecage.com> wrote in message news:joel....@thecodecage.com...

Raz Boyarski

unread,

Feb 20, 2010, 4:45:17 PM2/20/10

to

I already tried that, and whenever the recipient is trying to read the mail
you sent, he gets a security warning about downloading pictures from another
server.
I guess this security warning is just in our exchange server but I'm not
sure..

anyway, it's not a good idea, but thanks.

> Hi Raz
>
> I never use/test it but I think I try to link to a picture on the web
>
> StrBody = "<table><td valign=""top""><img
> src=""http://www.lalala.com/header.png"" alt=""My logo"" " & _
> "width=""600"" height=""120"" hspace=""10""
> vspace=""10"" align=""left"" border=""0"" /></td>" & _
> "<tr></table>"

Raz Boyarski

unread,

Feb 20, 2010, 4:46:57 PM2/20/10

to

HTML files usually comes with side files such as scripts, databases, and
PICTURES.

Outlook doesn't support XMLT files or any other complicated "Single htm"
files..

> Ron: I don't think we need to link the picture into a webpage, instead
> we need to put the picture into a HTML file so the image can be seen
> by the receiver of the e-mail.
>
> I can put a picture into a webpage and save the page as an XMLT a get
> the the picture saved into the file (not a link). but haven't found
> the trick in to getting the picture into an html. Can you read an
> XMLT into an email?
>

joel

unread,

Feb 20, 2010, 5:04:04 PM2/20/10

to

A digital signature shouldn't be very large. I thought just saving a
word document should of done.

UpGrade

unread,

Feb 20, 2010, 7:13:09 PM2/20/10

to

On Sat, 20 Feb 2010 21:46:57 +0000 (UTC), Raz Boyarski
<spo...@gmail.com> wrote:

>HTML files usually comes with side files such as scripts, databases, and
>PICTURES.
>
>Outlook doesn't support XMLT files or any other complicated "Single htm"
>files..
>
>

Maybe you have an old version. It is xml capable now.

Ron de Bruin

unread,

Feb 21, 2010, 6:00:42 AM2/21/10

to

You can turn that warning of in Outlook
For all or only for one

I hope I have time this week to play with it

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Raz Boyarski" <spo...@gmail.com> wrote in message news:9289ea6747728...@nntp.aioe.org...

Draikonis

unread,

Aug 9, 2010, 8:09:24 AM8/9/10

to

Hey there.

I am currently experiencing the same problem. After som truobleshooting
I discovered that the GetBoiler function (created by **** Kusleika)
provided in Ron the Bruin's code cannot handle images. Therefore the
image link look broken. Try saving you newly created e-mail as a HTML
document, open it in a web browser and look at the source code. The file
path to the image in the signature is changed for some reason.

We need to look for another function. I guess all ****'s function does
is finding the file and open it and read it?

Sincerely
Amanda

--
Draikonis
------------------------------------------------------------------------
Draikonis's Profile: http://www.thecodecage.com/forumz/member.php?u=2285

View this thread: http://www.thecodecage.com/forumz/showthread.php?t=181074

http://www.thecodecage.com/forumz

--- news://freenews.netfront.net/ - complaints: ne...@netfront.net ---