Hi Jimmy, I changed the behavior, and I did get the email.
I hate to be such a bother, but it is still not working like I want it to work. For testing I only added two records to the email body: OrderID OrderLastName. The next thing I did rather intuitively, and of course it didn't work :)
I created a simple recordset from the orders table. I used that recordset to insert the information into the email body.
On the email I received, the OrderID showed 37 (it was order number 43) and the OrderLastName showed nothing. Could you let me know what I am doing wrong?