If I am reading this correctly, I think the issue is that you will need to add the recordset to the page:
WAATKusers
before you can include the details from the recordset in the link. If you want it to appear as a link, just include the full location including www.yourdomain.com/ and most email clients will automatically show it as a link.