SELECT EMail FROM zTmp_CakePros #variables.Name#
INSERT INTO tbl_FSPro_Members(OwnerID, FSL_tableCode, LastName, email, email_frmt, createDate, staffmember ) VALUES (153, 'MSC', '#variables.Name#', '#GetMems.EMail#', 'H', getDate(), 0); SELECT * FROM zTmp_CakePros ORDER BY FULL_NAme INSERT INTO tbl_FSPro_Members(OwnerID, FSL_tableCode, salutation, firstname, LastName, Title, City, State, email, email_frmt, createDate, staffmember ) VALUES (153, 'MSC', '#GetMems.salutation#', '#GetMems.FirstName#', '#variables.lastName#', '#GetMems.title#', '#GetMems.city#', '#left(GetMems.STATE_PROVINCE,2)#', '#GetMems.EMail#', 'H', getDate(), 0); SELECT NewUserID = @@IDENTITY SET NOCOUNT OFF INSERT INTO tbl_SEC_MemGrpLink(FSPro_UserID, GroupID) VALUES(#InsMems.NewUserID#,4554) #GetMems.full_Name#||#variables.lastname#