Formatting a HtmlBody email string to include variables

Tom Petersen · Oct 13, 2005

I have this:
1 emailBody = "<html>" & vbCrLf _
2 & "<head>" & vbCrLf _
3 & "<title>Interpreter Request details</title> " &
vbCrLf _
4 & "</head> " & vbCrLf _
5 & "<body> " & vbCrLf _
6 & "Interpreter Request
details: " & vbCrLf _
7 & "Requestor: <% strFName strLName %>"
& vbCrLf _
...
& "</body> " & vbCrLf _
& "</html> " & vbCrLf

In line 7, I need to display the results of the variables strFName and
strLName (and have a space in between the two) but I don't know the proper
formatting. If I just use the & then I get the literal strFname instead of
the value. Could someone please show me the correct syntax for this?

TIA!

Paxton · Oct 13, 2005

Tom said:
I have this:
1 emailBody = "<html>" & vbCrLf _
2 & "<head>" & vbCrLf _
3 & "<title>Interpreter Request details</title> " &
vbCrLf _
4 & "</head> " & vbCrLf _
5 & "<body> " & vbCrLf _
6 & "Interpreter Request
details: " & vbCrLf _
7 & "Requestor: <% strFName strLName %>"
& vbCrLf _
...
& "</body> " & vbCrLf _
& "</html> " & vbCrLf

In line 7, I need to display the results of the variables strFName and
strLName (and have a space in between the two) but I don't know the proper
formatting. If I just use the & then I get the literal strFname instead of
the value. Could someone please show me the correct syntax for this?

TIA!

Line 7: & "Requestor: " & strFName & " " & strLName & ""
& vbCrLf _

assuming you want a space between strFName and strLName

Paxton

Tom Petersen · Oct 13, 2005

That worked great, what a pain! Thanks!

One last thing, my vbCrLf doesn't seem to work, isn't that supposed to be a
carriage return? Everthing is on the same line and I need it to have an
'enter' after some of the lines...

Phill. W · Oct 13, 2005

Tom Petersen said:
I have this:
1 emailBody = "<html>" & vbCrLf _ .. . .
In line 7, I need to display the results of the variables strFName
and strLName (and have a space in between the two) but I don't
know the proper formatting.

Remember, all you're doing is building up a String that "just happens"
to have HTML in it.

emailBody = "<html>" & vbCrLf _
. . .
& "<body>" & vbCrLf _
& ""
& Interpreter Request details: " & " " & vbCrLf _
& "Requestor: " _
& strFName & " " & strLName _
& "" & " " & vbCrLf _
. . .
& "</body> " & vbCrLf _
& "</html> " & vbCrLf

Note the use of " " & vbCrLf to force an HTML-style line
break - HTML does not care about white-space; only HTML tags.

HTH,
Phill W.

Paxton · Oct 13, 2005

VbCrLf is for line breaks in text emails. does it in html.

So line 6 and 7 should look like this:

6 & "Interpreter Request details: " & _
7 & "Requestor: " & strFName & " " & strLName & " & _
etc....

Paxton

Tom Petersen · Oct 13, 2005

just call me Homer Simpson! I knew that! Thanks for all of the help!!!

Syntax problem with HTML output in email	4	Oct 23, 2003
Script stops working when using variables to save time typing...	4	Oct 31, 2022
CDONTS.NewMail.1 error '80020009' unable to connect to server	1	Aug 5, 2004
ASP, XML stuff...	6	May 31, 2006
Cannot figure out error in asp code	2	Jul 25, 2004
I'm about to get in trouble with the HTML <body></body> tags	10	Aug 12, 2023
Sending CDONTS HTML email issue	5	Mar 23, 2005
Help w/ syntax to have body of email include form fields	2	Mar 22, 2006

Formatting a HtmlBody email string to include variables

Tom Petersen

Paxton

Tom Petersen

Phill. W

Paxton

Tom Petersen

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads