Adding an image signature to an Email generated from VBA

[Raz Boyarski]

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]

See ron Debruin's webpage

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

 

[Raz Boyarski]

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

 

[joel]

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

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

 

[Raz Boyarski]

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...

 

[Ron de Bruin]

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

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.

Microsoft Office
Help

 

[joel]

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

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

 

[Ron de Bruin]

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

 

[Raz Boyarski]

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>"

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.

Microsoft Office
Help

 

[Raz Boyarski]

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..

 

[joel]

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

 

[UpGrade]

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]

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

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>"

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.

Microsoft Office
Help

 

[Draikonis]

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: (e-mail address removed) ---