How to send unique id in email

[ScottR]

Step 1 Insert record?
Step 2 Send email?

If so check out what I posted here using RETURNING

Pass Variable declared in SQL to another SQL Query

the declare works fine for setting the variable within the sql statment. But how do i get the variable CustomerId passed to a new sql query?