Send a mail with informations from 2 tables.

Quote Anothersledhead:

I did a similar thing in an application I built. Here is how I did it.

1) I created a record with a custom SQL statement as a datasource.

2) I then wrote the SQL statement something to this effect ---SELECT customers.customer_email AS to_email, CONCAT(customers.customer_name, " your quote is ready") AS subject CONCAT("Your quote is ready you can login to view it at http://www.somedomain.com with the following username and password<br><br>Username: ", users.user_login, "<br><br>Password: ", users.user_password) AS body FROM customers, users WHERE customers.customer_id = users.customer_id ----

3) Now create three text boxes and one text area on the record form.

4) Name the three text boxes and text area to_email, from_email, subject and body respectively. By naming the controls the same as your SQL statement they should now populate when the page loads. You will need to fill in the from email yourself.

5) Like yourself I didn't need to save the data so I removed all of the buttons except the cancel button. I then duplicated the cancel button and then renamed one of the buttons send.

6) I then set the onclick event of the renamed cancel button to send the email.

There might be a cleaner way of doing things but this works fine for me it also allows you to edit the email before it goes out.

Hope this makes sense

Quote peterr:

Philippe,

Have you maybe tried:
a) the method described at http://docs.codecharge.com/studio/html/QuickStart/EnhAp...SendEmails.html
b) the Send Email action: http://docs.codecharge.com/studio/html/Actions/Server/Send%20Email.html

In both cases you would use that code or action in the "After Update" or "After Insert" event, but if you don't need to update the database then you can use the Search form (it is sam as Record form but it doesn't have Data Source) and use OnClick event of the Search button (rename it to "Submit"), or maybe in the page's After Initialize event check if any parameters were submitted by the Search form and then use them to create the email.
I haven't tested these approaches, so these are just general ideas.