Thanks that works however, I'm still not getting the report via email when I run my SQL job. Database mail is working. Is the only line I need to change SET @vRecipients? Thanks for your patience.