select ownerId, ownerType, toUserId, config, requestId from tbl_WRK_userRequests where ownerId = 26 and ownerType = 'MFR' and handlerTemplatePath = '/mstrcfmod/MFR26/monthlyBusinessReview' and disposition = 'X' and config like '%forwarded=false%' select firstName, lastName, email from tbl_fspro_members with (nolock) where ownerId = and fsl_tablecode = and fspro_userId = select c.mainFolder, c.subFolder, c.fileName, r.docTitle from tbl_TER_Repository r with (nolock) inner join tbl_FSC_COntent c with (nolock) on c.contentId = r.contentId where r.ownerId = and r.ownerType = and r.containerType = 'TER' and r.containerId = and r.fileId = select * from qmd_recipients order by email, territoryName

Below are links to the Monthly Region Hows Business Reports that have been auto-generated and distributed from the CRM system. Click on a link below to review the report.

Monthly Business Reports	Provided By
#htmleditformat( linkTitle )#	#htmleditformat( rsmFirstName )# #htmleditformat( rsmLastName )#

#_outputHTML#

To: #htmleditformat( firstName )# #htmleditformat( lastName )# <#htmleditformat( email )#>

#_bodyHTML#

#_outputHTML# update tbl_WRK_userRequests set config = where ownerId= and ownerType = and requestId =