Think order of operations.
the code order on your page is:
* Create recordsets that look up the order info
* Store the order info to the database
* Send the email containing the order info using the recordsets
Since the recordsets are created before the information is saved to the databases, they are not returning a result.
you need to reorder the code so the recordsets come after saving the information to the database and before sending the email for them to work.