Embed image in CDOSYS message

Manuel · Jul 13, 2006

Is it possible to embed an image, like a company logo in a CDOSYS generated
message?
If yes, IÂ´ll apreciate some code sample. IÂ´ve been able to format messages
in html the way I like, but I can't figure out how to embed an image.
Thanks for your time.

James Jones · Jul 13, 2006

well since u kno how to embed HTML, just use the the img tag

connName.HTMLBody = "<img src=""URL TO IMAGE"" height=""XX"" width=""XX"">

change the connName to ur connection name.
change URL TO IMAGE to the link to ur images u wanna embed.

change height and width as needed. if ur not gonna mess with these
attributes, then just remove them.

note that i have used 2 sets of quoation marks on each side of the value.

"URL TO IMAGE"

will throw you an error, and will not send ur message.

""URL TO IMAGE""

is the correct format.

Hope this helps
Jay

Manuel · Jul 13, 2006

Thanks for your help James. I think we're almos there. What's happening now
is that the message that is sent and I Cc it to myself, comes up in outlook
with that protection asking to right click the image to see it. But when I do
that, nothing happens and the option of the right click to see the image
disappears. Any ideas.
Thanks a million

James Jones · Jul 13, 2006

mayb the image URL is incorrect...

verify every path is correct everywhere.......make sure u can view images in
outlook as well.

Manuel · Jul 13, 2006

James,
IÂ´m pasting the code that I have now. I hope you bypass the portuguese
language issue.
As you can see, this is a confirmation message of the record insertion in
SQL2000 Server database. I hope this will help you better in your guidance.
Everything works just fine except for the image part as IÂ´ve described in
the previous post.
Thanks again for your pacience.

<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Iterartis_Web_STRING
Recordset1.Source = "SELECT ID, Nome, Cidade, Pais, Email, Telefone,
Telemovel, Nome_Contacto, Data_Prevista, Cidade_Origem, Cidade_Destino,
Descricao_Conteudos FROM dbo.contacto_tbl ORDER BY ID DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 1

Dim strNome, strCidade, strPais, strEmail, strTelefone, strTelemovel,
strContacto, strDataPrevista, strCidadeOrigem, strCidadeDestino,
strDescricao, strImage
Dim strBody

strNome = Recordset1("Nome")
strCidade = Recordset1("Cidade")
strPais = Recordset1("Pais")
strEmail = Recordset1("Email")
strTelefone = Recordset1("Telefone")
strTelemovel = Recordset1("Telemovel")
strContacto = Recordset1("Nome_Contacto")
strDataPrevista = Recordset1("Data_Prevista")
strCidadeOrigem = Recordset1("Cidade_Origem")
strCidadeDestino = Recordset1("Cidade_Destino")
strDescricao = Recordset1("Descricao_Conteudos")

strBody = strBody & "<img src=""/images/Logo.gif""/>" & " " & " "

strBody = strBody & "FormulÃ¡rio que nos foi enviado na
Data/Hora:</td>" & ""& " " & Now() & vbCrLf & " " & ""

strBody = strBody & "From:" & " http://" & Request.ServerVariables("HTTP_HOST") &
vbCrLf & " " & " " & ""

strBody = strBody & "IP: " & "" & " " & Request.ServerVariables("REMOTE_ADDR") & vbCrLf &
" " & " " & ""

strBody = strBody & "Nome:" & "" & " " & strNome &" " & " " & ""

strBody = strBody & "Cidade:" & "" & " " & strCidade &" " & " " & ""

strBody = strBody & "PaÃs:" & "" & " " & strPais &" " & " " & ""

strBody = strBody & "Email:" & "" & " " & strEmail &" " & " " & ""

strBody = strBody & "Telefone:" & "" & " " & strTelefone &" " & " " &
""

strBody = strBody & "TelemÃ³vel:" & "" & " " & strTelemovel &" " & " " &
""

strBody = strBody & "Nome do Contacto:" & "" & " " & strContacto &" " &
" " & ""

strBody = strBody & "Data Prevista:" & "" & " " & strDataPrevista &" " & " " &
""

strBody = strBody & "Cidade de Origem:" & "" & " " & strCidadeOrigem
&" " & " " & ""

strBody = strBody & "Cidade de Destino:" & "" & " " & strCidadeDestino
&" " & " " & ""

strBody = strBody & "ConteÃºdos: " & "" & " " & strDescricao &" " & " "

strBody = strBody & ""

Dim ObjSendMail
Set ObjSendMail = CreateObject("CDO.Message")

ObjSendMail.To = strEmail
ObjSendMail.Bcc = "(e-mail address removed)"
ObjSendMail.Subject = "ConfirmaÃ§Ã£o de Pedido de OrÃ§amento"
ObjSendMail.From = "(e-mail address removed)"

' we are sending a html email.. simply switch the comments around to send a
text email instead
ObjSendMail.HTMLBody = strBody
'ObjSendMail.TextBody = strBody

ObjSendMail.Send

Set ObjSendMail = Nothing

%>

Egbert Nierop \(MVP for IIS\) · Jul 13, 2006

Manuel said:
Is it possible to embed an image, like a company logo in a CDOSYS
generated
message?
If yes, IÂ´ll apreciate some code sample. IÂ´ve been able to format messages
in html the way I like, but I can't figure out how to embed an image.
Thanks for your time.

What you'd do best, is generate an email thorugh outlook or other program,
where the emails are embedded.
Sample. Use IE6 to save a website to a single page!
Then look at the contents of the page, it will be MIME 1.0 part encoded.

The MSDN has some samples.

Mike Brind · Jul 13, 2006

You need to host the image on a publicly accessible web server and
provide the full url in the src attribute:

<img src=""http://www.domain.pt/images/image.gif"">

Incidentally, all that string concatentation is terribly wasteful.
Each time you write strBody = strBody &, the ASP engine has to recreate
the string from scratch, as well as hold the current value of strBody
in memory. When I design an html email, I create it in Dreamweaver (or
some other WYSIWYG editor) then take the resulting html source, pop it
into word and run a tiny macro I created to double up on double quotes
and remove paragraphs. That gives me one long unbroken string.

Or you can use the underscore character:

strBody = "some text" & _
"some more text" & _
"even more text"

--
Mike Brind

James Jones said:
James,
I´m pasting the code that I have now. I hope you bypass the portuguese
language issue.
As you can see, this is a confirmation message of the record insertion in
SQL2000 Server database. I hope this will help you better in your guidance.
Everything works just fine except for the image part as I´ve described in
the previous post.
Thanks again for your pacience.

<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Iterartis_Web_STRING
Recordset1.Source = "SELECT ID, Nome, Cidade, Pais, Email, Telefone,
Telemovel, Nome_Contacto, Data_Prevista, Cidade_Origem, Cidade_Destino,
Descricao_Conteudos FROM dbo.contacto_tbl ORDER BY ID DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 1

Dim strNome, strCidade, strPais, strEmail, strTelefone, strTelemovel,
strContacto, strDataPrevista, strCidadeOrigem, strCidadeDestino,
strDescricao, strImage
Dim strBody

strNome = Recordset1("Nome")
strCidade = Recordset1("Cidade")
strPais = Recordset1("Pais")
strEmail = Recordset1("Email")
strTelefone = Recordset1("Telefone")
strTelemovel = Recordset1("Telemovel")
strContacto = Recordset1("Nome_Contacto")
strDataPrevista = Recordset1("Data_Prevista")
strCidadeOrigem = Recordset1("Cidade_Origem")
strCidadeDestino = Recordset1("Cidade_Destino")
strDescricao = Recordset1("Descricao_Conteudos")

strBody = strBody & "<img src=""/images/Logo.gif""/>" & " " & " "
[snipped]

Dim ObjSendMail
Set ObjSendMail = CreateObject("CDO.Message")

ObjSendMail.To = strEmail
ObjSendMail.Bcc = "(e-mail address removed)"
ObjSendMail.Subject = "Confirmação de Pedido de Orçamento"
ObjSendMail.From = "(e-mail address removed)"

' we are sending a html email.. simply switch the comments around to senda
text email instead
ObjSendMail.HTMLBody = strBody
'ObjSendMail.TextBody = strBody

ObjSendMail.Send

Set ObjSendMail = Nothing

%>

--
Manuel

James Jones said:

well since u kno how to embed HTML, just use the the img tag

connName.HTMLBody = "<img src=""URL TO IMAGE"" height=""XX"" width=""XX"">

change the connName to ur connection name.
change URL TO IMAGE to the link to ur images u wanna embed.

change height and width as needed. if ur not gonna mess with these
attributes, then just remove them.

note that i have used 2 sets of quoation marks on each side of the value.

"URL TO IMAGE"

will throw you an error, and will not send ur message.

""URL TO IMAGE""

is the correct format.

Hope this helps
Jay

Click to expand...

Manuel · Jul 13, 2006

Thank you Mike.

IÂ´ll make it one string immediatelly. Thanks for the advice. As for having to
be on a publicly accessible web server and provide the full url in the src
attribute, could I not have my server for testing purposes do the job and
instead of the
<img src=""http://www.domain.pt/images/image.gif""> have
<img src=""http://myIP/images/image.gif"">
To browse the website IÂ´m developing it works. But IÂ´ve tried that and it
didn't work. If it's not suppose to work, could you explain why? Thanks for
your pacience and thanks for the pt in the domain.
That was a kind note.
--
Manuel

Mike Brind said:
You need to host the image on a publicly accessible web server and
provide the full url in the src attribute:

<img src=""http://www.domain.pt/images/image.gif"">

Incidentally, all that string concatentation is terribly wasteful.
Each time you write strBody = strBody &, the ASP engine has to recreate
the string from scratch, as well as hold the current value of strBody
in memory. When I design an html email, I create it in Dreamweaver (or
some other WYSIWYG editor) then take the resulting html source, pop it
into word and run a tiny macro I created to double up on double quotes
and remove paragraphs. That gives me one long unbroken string.

Or you can use the underscore character:

strBody = "some text" & _
"some more text" & _
"even more text"

--
Mike Brind

James,
IÂ´m pasting the code that I have now. I hope you bypass the portuguese
language issue.
As you can see, this is a confirmation message of the record insertion in
SQL2000 Server database. I hope this will help you better in your guidance.
Everything works just fine except for the image part as IÂ´ve described in
the previous post.
Thanks again for your pacience.

<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Iterartis_Web_STRING
Recordset1.Source = "SELECT ID, Nome, Cidade, Pais, Email, Telefone,
Telemovel, Nome_Contacto, Data_Prevista, Cidade_Origem, Cidade_Destino,
Descricao_Conteudos FROM dbo.contacto_tbl ORDER BY ID DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 1

Dim strNome, strCidade, strPais, strEmail, strTelefone, strTelemovel,
strContacto, strDataPrevista, strCidadeOrigem, strCidadeDestino,
strDescricao, strImage
Dim strBody

strNome = Recordset1("Nome")
strCidade = Recordset1("Cidade")
strPais = Recordset1("Pais")
strEmail = Recordset1("Email")
strTelefone = Recordset1("Telefone")
strTelemovel = Recordset1("Telemovel")
strContacto = Recordset1("Nome_Contacto")
strDataPrevista = Recordset1("Data_Prevista")
strCidadeOrigem = Recordset1("Cidade_Origem")
strCidadeDestino = Recordset1("Cidade_Destino")
strDescricao = Recordset1("Descricao_Conteudos")

strBody = strBody & "<img src=""/images/Logo.gif""/>" & " " & " "
[snipped]

Dim ObjSendMail
Set ObjSendMail = CreateObject("CDO.Message")

ObjSendMail.To = strEmail
ObjSendMail.Bcc = "(e-mail address removed)"
ObjSendMail.Subject = "ConfirmaÃ§Ã£o de Pedido de OrÃ§amento"
ObjSendMail.From = "(e-mail address removed)"

' we are sending a html email.. simply switch the comments around to send a
text email instead
ObjSendMail.HTMLBody = strBody
'ObjSendMail.TextBody = strBody

ObjSendMail.Send

Set ObjSendMail = Nothing

%>

--
Manuel

James Jones said:

well since u kno how to embed HTML, just use the the img tag

connName.HTMLBody = "<img src=""URL TO IMAGE"" height=""XX"" width=""XX"">

change the connName to ur connection name.
change URL TO IMAGE to the link to ur images u wanna embed.

change height and width as needed. if ur not gonna mess with these
attributes, then just remove them.

note that i have used 2 sets of quoation marks on each side of the value.

"URL TO IMAGE"

will throw you an error, and will not send ur message.

""URL TO IMAGE""

is the correct format.

Hope this helps
Jay

Is it possible to embed an image, like a company logo in a CDOSYS
generated
message?
If yes, IÂ´ll apreciate some code sample. IÂ´ve been able to format messages
in html the way I like, but I can't figure out how to embed an image.
Thanks for your time.

Click to expand...

Click to expand...

Mike Brind · Jul 13, 2006

For testing purposes, of course you can replace the domain with an IP.
In fact, there's no reason why you can't retain the IP address and keep
the image there for the real thing. So long as the URL is the correct
one, I see no reason why it shouldn't work properly, unless your ISP
has some rules preventing remote hosting of images.

The pt domain? Thought you'd like that ;-)

--
Mike Brind

Mike Brind said:
Thank you Mike.

I´ll make it one string immediatelly. Thanks for the advice. As for having to
be on a publicly accessible web server and provide the full url in the src
attribute, could I not have my server for testing purposes do the job and
instead of the
<img src=""http://www.domain.pt/images/image.gif""> have
<img src=""http://myIP/images/image.gif"">
To browse the website I´m developing it works. But I´ve tried that and it
didn't work. If it's not suppose to work, could you explain why? Thanks for
your pacience and thanks for the pt in the domain.
That was a kind note.
--
Manuel

Mike Brind said:

You need to host the image on a publicly accessible web server and
provide the full url in the src attribute:

<img src=""http://www.domain.pt/images/image.gif"">

Incidentally, all that string concatentation is terribly wasteful.
Each time you write strBody = strBody &, the ASP engine has to recreate
the string from scratch, as well as hold the current value of strBody
in memory. When I design an html email, I create it in Dreamweaver (or
some other WYSIWYG editor) then take the resulting html source, pop it
into word and run a tiny macro I created to double up on double quotes
and remove paragraphs. That gives me one long unbroken string.

Or you can use the underscore character:

strBody = "some text" & _
"some more text" & _
"even more text"

--
Mike Brind

James,
I´m pasting the code that I have now. I hope you bypass the portuguese
language issue.
As you can see, this is a confirmation message of the record insertion in
SQL2000 Server database. I hope this will help you better in your guidance.
Everything works just fine except for the image part as I´ve described in
the previous post.
Thanks again for your pacience.

<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Iterartis_Web_STRING
Recordset1.Source = "SELECT ID, Nome, Cidade, Pais, Email, Telefone,
Telemovel, Nome_Contacto, Data_Prevista, Cidade_Origem, Cidade_Destino,
Descricao_Conteudos FROM dbo.contacto_tbl ORDER BY ID DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 1

Dim strNome, strCidade, strPais, strEmail, strTelefone, strTelemovel,
strContacto, strDataPrevista, strCidadeOrigem, strCidadeDestino,
strDescricao, strImage
Dim strBody

strNome = Recordset1("Nome")
strCidade = Recordset1("Cidade")
strPais = Recordset1("Pais")
strEmail = Recordset1("Email")
strTelefone = Recordset1("Telefone")
strTelemovel = Recordset1("Telemovel")
strContacto = Recordset1("Nome_Contacto")
strDataPrevista = Recordset1("Data_Prevista")
strCidadeOrigem = Recordset1("Cidade_Origem")
strCidadeDestino = Recordset1("Cidade_Destino")
strDescricao = Recordset1("Descricao_Conteudos")

strBody = strBody & "<img src=""/images/Logo.gif""/>" & " " & " "
[snipped]

Dim ObjSendMail
Set ObjSendMail = CreateObject("CDO.Message")

ObjSendMail.To = strEmail
ObjSendMail.Bcc = "(e-mail address removed)"
ObjSendMail.Subject = "Confirmação de Pedido de Orçamento"
ObjSendMail.From = "(e-mail address removed)"

' we are sending a html email.. simply switch the comments around to send a
text email instead
ObjSendMail.HTMLBody = strBody
'ObjSendMail.TextBody = strBody

ObjSendMail.Send

Set ObjSendMail = Nothing

%>

--
Manuel

:

well since u kno how to embed HTML, just use the the img tag

connName.HTMLBody = "<img src=""URL TO IMAGE"" height=""XX"" width=""XX"">

change the connName to ur connection name.
change URL TO IMAGE to the link to ur images u wanna embed.

change height and width as needed. if ur not gonna mess with these
attributes, then just remove them.

note that i have used 2 sets of quoation marks on each side of the value.

"URL TO IMAGE"

will throw you an error, and will not send ur message.

""URL TO IMAGE""

is the correct format.

Hope this helps
Jay

Is it possible to embed an image, like a company logo in a CDOSYS
generated
message?
If yes, I´ll apreciate some code sample. I´ve been able to format messages
in html the way I like, but I can't figure out how to embed an image.
Thanks for your time.

Click to expand...

Click to expand...

Manuel · Jul 13, 2006

Correction Mike:

It works beautifully. I had a wrong statement. Everything is already in one
string. Thanks once more for the lesson.
--
Manuel

Mike Brind said:
You need to host the image on a publicly accessible web server and
provide the full url in the src attribute:

<img src=""http://www.domain.pt/images/image.gif"">

Incidentally, all that string concatentation is terribly wasteful.
Each time you write strBody = strBody &, the ASP engine has to recreate
the string from scratch, as well as hold the current value of strBody
in memory. When I design an html email, I create it in Dreamweaver (or
some other WYSIWYG editor) then take the resulting html source, pop it
into word and run a tiny macro I created to double up on double quotes
and remove paragraphs. That gives me one long unbroken string.

Or you can use the underscore character:

strBody = "some text" & _
"some more text" & _
"even more text"

--
Mike Brind

James,
IÂ´m pasting the code that I have now. I hope you bypass the portuguese
language issue.
As you can see, this is a confirmation message of the record insertion in
SQL2000 Server database. I hope this will help you better in your guidance.
Everything works just fine except for the image part as IÂ´ve described in
the previous post.
Thanks again for your pacience.

<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Iterartis_Web_STRING
Recordset1.Source = "SELECT ID, Nome, Cidade, Pais, Email, Telefone,
Telemovel, Nome_Contacto, Data_Prevista, Cidade_Origem, Cidade_Destino,
Descricao_Conteudos FROM dbo.contacto_tbl ORDER BY ID DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 1

Dim strNome, strCidade, strPais, strEmail, strTelefone, strTelemovel,
strContacto, strDataPrevista, strCidadeOrigem, strCidadeDestino,
strDescricao, strImage
Dim strBody

strNome = Recordset1("Nome")
strCidade = Recordset1("Cidade")
strPais = Recordset1("Pais")
strEmail = Recordset1("Email")
strTelefone = Recordset1("Telefone")
strTelemovel = Recordset1("Telemovel")
strContacto = Recordset1("Nome_Contacto")
strDataPrevista = Recordset1("Data_Prevista")
strCidadeOrigem = Recordset1("Cidade_Origem")
strCidadeDestino = Recordset1("Cidade_Destino")
strDescricao = Recordset1("Descricao_Conteudos")

strBody = strBody & "<img src=""/images/Logo.gif""/>" & " " & " "
[snipped]

Dim ObjSendMail
Set ObjSendMail = CreateObject("CDO.Message")

ObjSendMail.To = strEmail
ObjSendMail.Bcc = "(e-mail address removed)"
ObjSendMail.Subject = "ConfirmaÃ§Ã£o de Pedido de OrÃ§amento"
ObjSendMail.From = "(e-mail address removed)"

' we are sending a html email.. simply switch the comments around to send a
text email instead
ObjSendMail.HTMLBody = strBody
'ObjSendMail.TextBody = strBody

ObjSendMail.Send

Set ObjSendMail = Nothing

%>

--
Manuel

James Jones said:

well since u kno how to embed HTML, just use the the img tag

connName.HTMLBody = "<img src=""URL TO IMAGE"" height=""XX"" width=""XX"">

change the connName to ur connection name.
change URL TO IMAGE to the link to ur images u wanna embed.

change height and width as needed. if ur not gonna mess with these
attributes, then just remove them.

note that i have used 2 sets of quoation marks on each side of the value.

"URL TO IMAGE"

will throw you an error, and will not send ur message.

""URL TO IMAGE""

is the correct format.

Hope this helps
Jay

Is it possible to embed an image, like a company logo in a CDOSYS
generated
message?
If yes, IÂ´ll apreciate some code sample. IÂ´ve been able to format messages
in html the way I like, but I can't figure out how to embed an image.
Thanks for your time.

Click to expand...

Click to expand...

Manuel · Jul 13, 2006

I loved it ;-)

Amazing. Half way around the world and you still can find caring people.
To another occasion IÂ´m sure.

Thanks again
--
Manuel

Mike Brind said:
For testing purposes, of course you can replace the domain with an IP.
In fact, there's no reason why you can't retain the IP address and keep
the image there for the real thing. So long as the URL is the correct
one, I see no reason why it shouldn't work properly, unless your ISP
has some rules preventing remote hosting of images.

The pt domain? Thought you'd like that ;-)

--
Mike Brind

Thank you Mike.

IÂ´ll make it one string immediatelly. Thanks for the advice. As for having to
be on a publicly accessible web server and provide the full url in the src
attribute, could I not have my server for testing purposes do the job and
instead of the
<img src=""http://www.domain.pt/images/image.gif""> have
<img src=""http://myIP/images/image.gif"">
To browse the website IÂ´m developing it works. But IÂ´ve tried that and it
didn't work. If it's not suppose to work, could you explain why? Thanks for
your pacience and thanks for the pt in the domain.
That was a kind note.
--
Manuel

Mike Brind said:

You need to host the image on a publicly accessible web server and
provide the full url in the src attribute:

<img src=""http://www.domain.pt/images/image.gif"">

Incidentally, all that string concatentation is terribly wasteful.
Each time you write strBody = strBody &, the ASP engine has to recreate
the string from scratch, as well as hold the current value of strBody
in memory. When I design an html email, I create it in Dreamweaver (or
some other WYSIWYG editor) then take the resulting html source, pop it
into word and run a tiny macro I created to double up on double quotes
and remove paragraphs. That gives me one long unbroken string.

Or you can use the underscore character:

strBody = "some text" & _
"some more text" & _
"even more text"

--
Mike Brind

Manuel wrote:
James,
IÂ´m pasting the code that I have now. I hope you bypass the portuguese
language issue.
As you can see, this is a confirmation message of the record insertion in
SQL2000 Server database. I hope this will help you better in your guidance.
Everything works just fine except for the image part as IÂ´ve described in
the previous post.
Thanks again for your pacience.

<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Iterartis_Web_STRING
Recordset1.Source = "SELECT ID, Nome, Cidade, Pais, Email, Telefone,
Telemovel, Nome_Contacto, Data_Prevista, Cidade_Origem, Cidade_Destino,
Descricao_Conteudos FROM dbo.contacto_tbl ORDER BY ID DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 1

Dim strNome, strCidade, strPais, strEmail, strTelefone, strTelemovel,
strContacto, strDataPrevista, strCidadeOrigem, strCidadeDestino,
strDescricao, strImage
Dim strBody

strNome = Recordset1("Nome")
strCidade = Recordset1("Cidade")
strPais = Recordset1("Pais")
strEmail = Recordset1("Email")
strTelefone = Recordset1("Telefone")
strTelemovel = Recordset1("Telemovel")
strContacto = Recordset1("Nome_Contacto")
strDataPrevista = Recordset1("Data_Prevista")
strCidadeOrigem = Recordset1("Cidade_Origem")
strCidadeDestino = Recordset1("Cidade_Destino")
strDescricao = Recordset1("Descricao_Conteudos")

strBody = strBody & "<img src=""/images/Logo.gif""/>" & " " & " "

[snipped]

Dim ObjSendMail
Set ObjSendMail = CreateObject("CDO.Message")

ObjSendMail.To = strEmail
ObjSendMail.Bcc = "(e-mail address removed)"
ObjSendMail.Subject = "ConfirmaÃ§Ã£o de Pedido de OrÃ§amento"
ObjSendMail.From = "(e-mail address removed)"

' we are sending a html email.. simply switch the comments around to send a
text email instead
ObjSendMail.HTMLBody = strBody
'ObjSendMail.TextBody = strBody

ObjSendMail.Send

Set ObjSendMail = Nothing

%>

--
Manuel

:

well since u kno how to embed HTML, just use the the img tag

connName.HTMLBody = "<img src=""URL TO IMAGE"" height=""XX"" width=""XX"">

change the connName to ur connection name.
change URL TO IMAGE to the link to ur images u wanna embed.

change height and width as needed. if ur not gonna mess with these
attributes, then just remove them.

note that i have used 2 sets of quoation marks on each side of the value.

"URL TO IMAGE"

will throw you an error, and will not send ur message.

""URL TO IMAGE""

is the correct format.

Hope this helps
Jay

Is it possible to embed an image, like a company logo in a CDOSYS
generated
message?
If yes, IÂ´ll apreciate some code sample. IÂ´ve been able to format messages
in html the way I like, but I can't figure out how to embed an image.
Thanks for your time.

Click to expand...

Click to expand...

Egbert Nierop \(MVP for IIS\) · Jul 14, 2006

Manuel said:
Thanks for the help.
What IÂ´ve done was to send an email to myself in html format with the logo
that I need in it.
Then IÂ´ve looked at the html code and copy the src as it was to the CDOSYS
message.

<img width=192 height=36
id="_x0000_i1025" src="cid:[email protected]">

When IÂ´ve send it, it complain of an end of statement expected just after
the 36.

You're at it, nearly, but you'll have to rename the images, and embed them
as base64 attachments.
CDOSYS cannot do it all alone.
I've included a sample, but I've cut short the base64 stuff, because it
won't be allowed by MS to attache huge files.

So, you would need to create more bodyparts (see CDOSYS docs) and some body
parts are
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

And the others are

Content-Type: image/jpeg
Content-Transfer-Encoding: base64

I have tiny a C++ COM utility (40KB) that very easily can do it for you,
encoding a single file into base64.
This can be called by scripting as well.

So IÂ´ve remove the with and height, put double quotes where single ones
were, and send. No errors. But now the message arrives and not even the
image
placeholder is there.

Then IÂ´ve put the correct url of the image like this:

<img src:""cid:/images/logo50.gif""> and send it. Again no errors but
again
no placeholder.

I donÂ´t know if IÂ´ve followed correctly your instruction, but IÂ´m still
stuck.

Another trick would be to have the images with an absolute URL to your
webserver. However, spam filters, will see that sort of mail as spyware.

Manuel · Jul 14, 2006

Thanks Egbert for your reply.
I got an encoded utility.
Now, my question is about adding the body parts that you mention.
First IÂ´ve initiated the string of the mail body with
strBody ="<img src=""cid=/images/logocdosys.jpeg"">" & " " & " " & _
Then I have

Dim ObjSendMail
Set ObjSendMail = CreateObject("CDO.Message")
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Content-Type: image/jpeg
Content-Transfer-Encoding: base64

ObjSendMail.To = strEmail
ObjSendMail.Bcc = "myEmail"
ObjSendMail.Subject = "ConfirmaÃ§Ã£o de Pedido de OrÃ§amento"
ObjSendMail.From = "myEmail"

ObjSendMail.HTMLBody = strBody

ObjSendMail.Send

Set ObjSendMail = Nothing

This comes up with the error:
Microsoft VBScript compilation error '800a03ea'

Syntax error

/email.asp, line 61

Content-Type: text/html;
--------^
What am I still missing?

Thanks for your time, but although I have it running using the full URL
path, IÂ´d like to learn this method.

Egbert Nierop \(MVP for IIS\) · Jul 14, 2006

Manuel said:
Thanks Egbert for your reply.
I got an encoded utility.
Now, my question is about adding the body parts that you mention.
First IÂ´ve initiated the string of the mail body with
strBody ="<img src=""cid=/images/logocdosys.jpeg"">" & " " & " " & _
Then I have

Dim ObjSendMail
Set ObjSendMail = CreateObject("CDO.Message")
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Content-Type: image/jpeg
Content-Transfer-Encoding: base64

ObjSendMail.To = strEmail
ObjSendMail.Bcc = "myEmail"
ObjSendMail.Subject = "ConfirmaÃ§Ã£o de Pedido de OrÃ§amento"
ObjSendMail.From = "myEmail"

ObjSendMail.HTMLBody = strBody

These methods, HTMLBody etc, are shortcuts but in fact, CDOSYS in not really
easy to use

http://msdn.microsoft.com/library/d...html/2dea7d01-cc18-4c66-8bf6-9d21a0f0547a.asp

So if you use the method above, from a 'standard HTML page' (can also be
locally) it will convert this for you!

Manuel · Jul 14, 2006

Thanks Egbert,

IÂ´ll be studying the references that you mention.

Anthony Jones · Jul 14, 2006

Manuel said:
Is it possible to embed an image, like a company logo in a CDOSYS generated
message?
If yes, I´ll apreciate some code sample. I´ve been able to format messages
in html the way I like, but I can't figure out how to embed an image.
Thanks for your time.

Yet another option is to use the CreateMHTMLBody method of the CDOSYS
Message object.

You create an ASP page that generates the html content that you want the
receipents to see.

You then simply supply the URL of this ASP page to the CreateMHTMLBody
method. It will build a html body along appropriate references to body
parts that it will create for you as well.

Eg.

MyHTMLContent.asp

<html>
<body>
Hello World<.br />
<img src="photo.gif" />
</body>
</html>

MyEmail generator:-

Dim oMsg : Set oMsg = Server.CreateObject("CDO.Message")

oMsg.From = ...
oMsg.To = ...
..
..
..
oMsg.CreateMHTMLBody = "http://" & Request.ServerVariables("SERVER_NAME") &
"/somefolder/MyHTMLContent.asp"

oMsg.Send

HTH,

Anthony.

Manuel · Jul 14, 2006

Thanks Anthony,

ThatÂ´s actually a great piece of information. No doupt I'll be trying it.
Learned one more today ;-)

Egbert Nierop \(MVP for IIS\) · Jul 14, 2006

Manuel said:
Thanks Egbert,

IÂ´ll be studying the references that you mention.

For some reason I posted the wrong reference.

This one is which you need.

http://msdn.microsoft.com/library/e...ed-d986-47fa-874f-2b36a9d50e03.asp?frame=true

Manuel · Jul 14, 2006

Thanks Egbert,

Already had a look and it makes sense to me. Actually I was confused on the
previous link ;-)

Manuel · Jul 15, 2006

Egbert,

I would like to thank you, as this reference did it. It's running and base64
encoded

To next time.

Defer code not working for image embedded from Google drive	1	May 8, 2022
Multi-part messages with CDOSYS	0	Aug 30, 2007
Image upload not working in browser	4	Sep 9, 2022
Setting message priority with CDOSYS	6	Jul 18, 2004
Code For New Image Every Time The Page Refreshes?	0	Dec 11, 2021
Error 8004020f when using CDOSYS	2	Jul 14, 2007
Image overlay and comparison code error.	2	Jul 1, 2021
Embed image in html with ajax	6	Jun 29, 2007

Embed image in CDOSYS message

Manuel

James Jones

Manuel

James Jones

Manuel

Egbert Nierop \(MVP for IIS\)

Mike Brind

Manuel

Mike Brind

Manuel

Manuel

Egbert Nierop \(MVP for IIS\)

Manuel

Egbert Nierop \(MVP for IIS\)

Manuel

Anthony Jones

Manuel

Egbert Nierop \(MVP for IIS\)

Manuel

Manuel

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads