Email multiple sets

Reply
Occasional Contributor
Posts: 7

Email multiple sets

I am looking for a way to send email out to supervisor from SAS that is group by supervisor.  Below is an example of the data:

Data

User                 Supervisors                  Key Fob

John Jones       Chris Rock                  123456789

Joe Black         Joe White                    987654321

Sue Love         Joe White                    123654789

Mary Dove      Stacy Pink                   123456987

Mike Blue       Joe White                    987456321

Red Button     Chris Rock                  987654123

Stacy Pink       Santa Claus                 654123987

Peter Rabbit    Jones Purple                456987123

Each email should look like the following for each supervisor sent out:

Dear Chris Rock

As part of verification of key fobs, you have been identified as a supervisor. Please approve or deny remote access for the staff listed below.

Once completed, please sign and return this document to the IPO on or before (date sent email + 14 days).

Employer Name          Token SN

John Jones                   123456789

Red Button                 987654123

Next email

Dear Joe White

As part of verification of key fobs, you have been identified as a supervisor. Please approve or deny remote access for the staff listed below.

Once completed, please sign and return this document to the IPO on or before (date sent email + 14 days).

Employer Name          Token SN

Joe Black                     987654321

Sue Love                     123654789

Mike Blue                   987456321

Next email

Dear Stacy Pink

As part of verification of key fobs, you have been identified as a supervisor. Please approve or deny remote access for the staff listed below.

Once completed, please sign and return this document to the IPO on or before (date sent email + 14 days).

Employer Name          Token SN

Mary Dove                  123456987

Ask a Question
Discussion stats
  • 0 replies
  • 116 views
  • 0 likes
  • 1 in conversation