Jump to content
  • 0

Sending filtered Table Variable via Task Email Addressed based on filter



Hi. I am stumped by a problem. 

I have nurses who screen patients for clinical trials.  Once they screen, they enter a date into a follow-up field. I would like to send a email every Monday with a list of the patients who have follow-up dates coming in the next week. 

I have created a task with a table variable that looks like this. I didn't include it but the WHERE portion where I set the 7 day window works fine. In the exxample below, Screening.User_ID is the Nurse and I join it with User.User_ID so that I can access the nurse's email. 


The email portion is also working fine.


There are two nurses (Ginger & Ivana) who have patients with follow-up dates in the next 7 days. And Both Ginger and Ivana receive their own email with the table. 



The problem is that I want the email to Ginger to only contain Ginger's patients and the email to Ivana to only contain Ivana's patients.  

Any help would be so greatly appreciated!

Thank you!


Link to comment
Share on other sites

3 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...