OK, then that is the problem.
You will want to create the random password as a session variable. Then you can refer to that session variable as both the database field and in the body of the email.
Use the Set Session Value server behavior that comes with eCart and/or cookies toolkit, or just write the code by hand on top of the page:
Session("verificationcode") = cStr(WA_RandomPassword(9, true, true, true, "")
Then in the Insert it becomes:
WA_fieldValuesStr = "" & cStr(cStr(Request.Form("Email"))) & "" & "|" & "" & cStr(cStr(Request.Form("FirstName"))) & "" & "|" & "" & cStr(Session("verificationcode")) & ""
and in the email it becomes:
Mailbody = Mailbody & cStr(Session("verificationcode"))