Announcement

**Pat Bremkamp** · 11-18-2007, 01:40 PM

Re: HTML Page in email body

Toby,

If you use email_send2(), there is a message.Html_Message component that will send the html portion. In addittion, if you also send the message.Message text component, Email_Send2() will use the non-html component if the user's email doesn't accept html bodies.

Pat

**Steve Wood** · 11-18-2007, 04:03 PM

Re: HTML Page in email body

All of the send email functions can send html in the body. They can send plain text, html text or both as a multipart message. Read the Alpha Help on email_send() if you want to use that function.

**EricN** · 02-24-2008, 10:02 PM

Re: HTML Page in email body

I see you can use both email_send and email_send2() when you wish to use the email function to include html.

But, how about placing fields from a table that can be merged into the email body?

pm.html_message = <<%html%
<html>
<head> </head>
<body>
Hello [user_name]
You have registered under the company name of, [Company_name]...
</body>
</html>
%html%
email_send2(pm)

Tried everything I can think of.

Thanks

**Steve Wood** · 02-25-2008, 02:46 AM

Re: HTML Page in email body

Seems like you should be able to put variables within the delimiters, but I've never figured out how. One method that would work is to create your string using delimiters as you have in your post, but put in "mailmerge codes" where you want to insert a variable, for instance ***companyname***. Then, after you create the entire string, use the stritrans() function to replace each occurance of the mergecode with the desired value.

stritran("mystring","***companyname***",tbl.companyname)

where mystring is your HTML message.

**Tim Kiebert** · 02-25-2008, 04:09 AM

Re: HTML Page in email body

The evaluate_string() function should do what you want.

Code:

dim user_name as C = "Eric"
dim Company_name as C = "Acme Trading Inc"

qq = <<%html%
<html>
<head> </head>
<body>
Hello {user_name}
You have registered under the company name of, {Company_name}...
</body>
</html>
%html%

aa = evaluate_string(qq)
?aa
= <html>
<head> </head>
<body>
Hello Eric
You have registered under the company name of, Acme Trading Inc...
</body>
</html>

**Steve Wood** · 02-25-2008, 04:25 AM

Re: HTML Page in email body

Very happy to learn that. I tested the following and it works. note - it does not work to put {tbl.name} directly within the delimiters.

Code:

dim tbl as p
tbl=table.open("prospects")
thishere = alltrim(tbl.name)
tbl.close()

body=<<%txt%

replace {thishere} with a local variable 

%txt%

body = evaluate_string(body)

email_send("[email protected]","test",body)

**EricN** · 02-25-2008, 02:48 PM

Re: HTML Page in email body

Thank you both for your answers. I took the following example from the help and implemented Tim's suggestion.
This works

dim user_name as C = "Eric developer"
dim Company_name as C = "Big Ice Berg Inc"
dim pm as P
pm.lrelated = .T.
pm.from = "[email protected]"
pm.from_alias = "Jane Doe"
pm.to = "[email protected]"
pm.subject = "Test"
pm.qq = <<%html%
<html>
<head> </head>
<body>
Hello {user_name}
You have registered under the company name of, {Company_name}...
</body>
</html>
%html%
pm.html_message = evaluate_string(pm.qq)
email_send2(pm)

Recipient receives via email: Hello Eric developer You have registered under the company name of, Big Ice Berg Inc...

**Tim Kiebert** · 02-25-2008, 03:44 PM

Re: HTML Page in email body

Eric, this worked for me.

Code:

dim user_name as C = "Eric"
dim Company_name as C = "Acme Trading Inc"
dim pm as P

'pm.attachments = " C:\login.jpg "
pm.lrelated = .T.
pm.from = "[email protected]"
pm.from_alias = "Jane Doe"
pm.to = "[email protected]"
pm.subject = "Test"

html_msg = <<%html%
<html>
<head> </head>
<body>
Hello {user_name}
You have registered under the company name of, {Company_name}...
</body>
</html>
%html%
pm.html_message = evaluate_string(html_msg)

email_send2(pm)

In your code although you 'did' the evaluate_template(qq) you did not assign it to any thing. ie it needs to be assigned to pm.html_message.

EDIT: Eric, I did not see your edit before I posted. I see you worked it out.

**EricN** · 02-25-2008, 07:39 PM

Re: HTML Page in email body

Hello Tim,
Yes I did get it figured out. Thanks. For my automatic emails, I use FrontPage to develop my pages. I place the code into them then I copy the code from FrontPage and paste it directly into my a5w code only page between the body and body. The email (code used above) automatically sends the html formatted page to the recipient and it looks great!

----------------------------------------------------------------------------------------------
Now I'm trying to develop a "Send to a friend" page using a dialog.

I placed the same code in the Aftervalidate

If eval_valid("session.Recnum")
session.Recnum= lookup("[pathalias.adb_path]\posts","Postnum=" +quote(session.Postnum),"Postnum")
end if

dim recnum as C = session.Recnum

dim pm as P
pm.lrelated = .T.
pm.from = CurrentForm.Controls.From
pm.from_alias = "SSN Administration"
pm.to = CurrentForm.Controls.Sendto
pm.bcc = "[email protected]"
pm.subject = "Job Opportunity"
pm.qq = <<%html%
<html>
<head> </head>
<body>
this is a test {recnum}
</body>
</html>
%html%
pm.html_message = evaluate_string(pm.qq)
email_send2(pm)

But I get this error!
Errors in: event.AfterValidate code:
Variable is of different type

Any ideas?

**Steve Wood** · 02-25-2008, 07:49 PM

Re: HTML Page in email body

There is a free code download on my website for Recommend to a Friend. Look on the For Developers page, section titled Free Alpha Components.

Sorry, there is supposed to be about 20 items here, but I am revamping my website and it only shows the one.

**EricN** · 02-25-2008, 07:55 PM

Re: HTML Page in email body

Do you mean "Refer A Friend" to let someone know about a website? I developed this for my site a long time ago.
OR
"Send A Copy Of A Job To A Friend" with several variables which is what I'm now trying to do?

**Steve Wood** · 02-25-2008, 08:07 PM

Re: HTML Page in email body

I think the former, its been a year since I looked. But I'm sure the model could be expanded to include variables.

**EricN** · 02-25-2008, 08:16 PM

Re: HTML Page in email body

Any idea of why I'm getting

Errors in: event.AfterValidate code:
Variable is of different type

in this dialog when it worked in my code only page? Recnum is character but contains numbers.

I do have a lot of time invested in this already.

**EricN** · 02-25-2008, 09:59 PM

Re: HTML Page in email body

It seems it is my CurrentForm.Controls.??? that is causing the error.

How can I get my values from the dialog into the pm. email system?

Announcement

The Alpha Software Forum Participation Guidelines

HTML Page in email body

HTML Page in email body

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment