Creating a multiple record email.

[Mojav]

Is is possible using conditional arguments or some other method... to write multiple records per single email.?

For example,

My database contains 1 record per staff person who is managed by a single manager.
"[email protected]","Joe Doe", "Health Analyst", USER1, "Jane Smith"
"[email protected]","Joe Adams", "Health Analyst", USER2, "Jane Smith"
"[email protected]","Joe Doaks", "Health Analyst", USER3, "Jane Smith"
"[email protected]","Joe Smith", "Health Analyst", USER4, "Jane Smith"

Our task could be to send 1 email to Jane Smith indicating all the 4 Joe's that have security access to be reviewed
like this:

Hi Jane,

The following staff are up for security review:

Joe Doe", "Health Analyst", USER1,
Joe Adams", "Health Analyst", USER2,
Joe Doaks", "Health Analyst", USER3,
Joe Smith", "Health Analyst", USER4,

Thanks,
Your IT Security reviewer...

 

[stanbusk]

Conditional statements only alter the message contents. Do you mean you want to Cc or Bcc a message to other 4 addresses?