since this is asp, you would need to use universal Email 3 for this.
you would need to create a recordset for the Orders table and another Order details table ,and set it to filter the orderID column of the order table on the order ID entered
then use the eCart Populate Cart from recordset behavior to populate the cart with the order details stored in the recordset
you can then add a Email friendly cart display object to your email in UE 3.