Oh, my bad. The email button does only appear when viewing the order.
As to your custom coding, the information is in the customers_email_address field of the orders table. You'll have to retrieve that field data in your query and then use it for preparing your link.
Bookmarks