Adding an image signature to an Email generated from VBA
 

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.

Adding an image signature to an Email generated from VBA
 

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

Adding an image signature to an Email generated from VBA
 

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

Adding an image signature to an Email generated from VBA
 

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

Adding an image signature to an Email generated from VBA
 

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

Adding an image signature to an Email generated from VBA
 

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

Adding an image signature to an Email generated from VBA
 

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

Microsoft Office Help

Adding an image signature to an Email generated from VBA
 

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

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

Microsoft Office Help

Adding an image signature to an Email generated from VBA
 

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

Adding an image signature to an Email generated from VBA
 

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?

Microsoft Office
Help

Adding an image signature to an Email generated from VBA
 

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


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

Microsoft Office Help

Adding an image signature to an Email generated from VBA
 

On Sat, 20 Feb 2010 21:46:57 +0000 (UTC), Raz Boyarski
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.

Adding an image signature to an Email generated from VBA
 

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

Adding an image signature to an Email generated from VBA
 

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

http://www.thecodecage.com/forumz


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