HTMLBody and variable

Serge Myrand · Aug 9, 2004

Hi everybody,

It seems that a variable cannot be assign to HTMLBody field. Am'I doing
something wrong?

- this line write a bold html phrase in the email body
..HTMLBody = "<HTML><HEAD><BODY>Here is the text body</BODY></HTML>"

- this line produce an empty body. The variable TableData contains all
the required HTML to construct the table. I Use Response.Write and see
all the code in it..
..HTMLBody = "<HTML><HEAD><BODY>" & TableData & "</BODY></HTML>"

thanks in advance

Aaron [SQL Server MVP] · Aug 9, 2004

HTMLBody field of what???

Serge Myrand · Aug 9, 2004

Hi,

The HTMLBody field of CDO.Message

ie:
with iMsg
.To =
.From =
.Subject =
.HTMLBody =
end With

thank's
serge

Aaron [SQL Server MVP] · Aug 9, 2004

Okay, so now that we know what you're talking about, can you give us more
details?

"It seems that a variable cannot be assign to HTMLBody field. Am'I doing
something wrong?"

What does "it seems" and "cannot be assign" mean? Do you get an error
message? If so, what is it? Or does something else happen? Could you do
us a favor and describe the actual symptom, instead of vague stories of
failure?

Serge Myrand · Aug 9, 2004

Hi Aaron,

The thing is that when I send and email and I construct the HTML code like
shown in the example n°1
the result is an HTML email showing the phrase (bold text): 'Here is the text
body'
In the example n° 2 the body of the email is empty, no text, nothing at all,
even if the variable TableData contains valid HTML code that construct a table
of several row with 5 columns of data. To make shure that TableData contains
all the required HTML code I dumped it on the screen using Response.Write. If
you prefer let say that TableData contains the phrase 'Here is the text body'

It seems mean 'on dirai que' or 'it looks like'. Cannot be assign mean 'If I
refer to a variable rather than a string'.
No I do not get any error message I get an empty body (just the sender and
receipient adresses nothing else).

My question is. Why the body of the email is empty when I assing a variable to
HTMLBody and it is not empty when I assing the HTML string (code) directly?
What I am doing wrong?

Example N°1: this line write a bold html text in the email body
..HTMLBody = "<HTML><HEAD><BODY>Here is the text body</BODY></HTML>"

Example N°2: this line produce an empty body even if the variable 'TableData'
contains all
the required HTML to construct the table.
..HTMLBody = "<HTML><HEAD><BODY>" & TableData & "</BODY></HTML>"

Thank you for your time
serge

Serge Myrand · Aug 10, 2004

Hi,

Forget about that it's my mistake. </TABLE> was missing in the variable
(TableData) containing the HTML code, resulting in an empty body email. But it
does not affect the result when using Response.Write TableData, the table
draws on the screen..!

thank you for your time
serge

Patrice · Aug 10, 2004

What if you add the missing closing head tag ?

Patrice
--

Serge Myrand said:
Hi Aaron,

The thing is that when I send and email and I construct the HTML code like
shown in the example n°1
the result is an HTML email showing the phrase (bold text): 'Here is the text
body'
In the example n° 2 the body of the email is empty, no text, nothing at all,
even if the variable TableData contains valid HTML code that construct a table
of several row with 5 columns of data. To make shure that TableData contains
all the required HTML code I dumped it on the screen using Response.Write. If
you prefer let say that TableData contains the phrase 'Here is the text body'

It seems mean 'on dirai que' or 'it looks like'. Cannot be assign mean 'If I
refer to a variable rather than a string'.
No I do not get any error message I get an empty body (just the sender and
receipient adresses nothing else).

My question is. Why the body of the email is empty when I assing a variable to
HTMLBody and it is not empty when I assing the HTML string (code) directly?
What I am doing wrong?

Example N°1: this line write a bold html text in the email body
.HTMLBody = "<HTML><HEAD><BODY>Here is the text body</BODY></HTML>"

Example N°2: this line produce an empty body even if the variable 'TableData'
contains all
the required HTML to construct the table.
.HTMLBody = "<HTML><HEAD><BODY>" & TableData & "</BODY></HTML>"

Thank you for your time
serge

Script to send email not working	1	Apr 10, 2023
About as basic "Newbie-Question" that you can get.	3	Sep 4, 2023
Snowing Effect	2	Apr 24, 2023
Help with code	0	Jun 12, 2022
Uhhhhh, What can I do next?	6	Nov 25, 2023
Loop through record in datareader in aspx for textbox other item	1	Sep 26, 2023
Top NOT top?	2	Feb 13, 2021
How to position the tooltip comment on these buttons?	9	Nov 4, 2023

HTMLBody and variable

Serge Myrand

Aaron [SQL Server MVP]

Serge Myrand

Aaron [SQL Server MVP]

Serge Myrand

Serge Myrand

Patrice

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads