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.

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/sh...d.php?t=181074

Microsoft Office Help

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)
Microsoft Office
Help

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/sh...d.php?t=181074

Microsoft Office Help

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

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" wrote in message ...
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