select firstname, lastname, email, title, b.broker_name as company from tbl_fspro_members m left outer join tblbrokers b on b.broker_id = m.ownerid and m.fsl_tablecode = 'bro' where m.fspro_userid =

User: #qryUser.firstname# #qryUser.lastname#
Company: #qryUser.company#
Title: #qryUser.title#
Email: #qryUser.email#

Message:
#form.emlMessage#