Hi Everyone, I need one help related to SAS automated email which send email to every other individuals.
Task is : There is 6 unique segments of videos link and its description which need to be send to customers.
suppose AAA customer is receiving 1 videos link and 1 video description and others can receive 2 or more videos link with its description for every customers.
Others customers can not see others email, it has to be send to every individual or row wise.
For example;
Link Desc: Collection Stratigies
Link: https://www.youtube.com/watch?v=6TK20Y5oD9s
need help to write sas code which can send email to this customers dynamically.
|
first_name
|
EMAIL_ADDRESS
|
Video_segment1
|
Video_segment2
|
Video_segment3
|
Video_segment4
|
Video_segment5
|
Video_segment6
|
|
AAA
|
AAA@COM
|
Yes
|
|
|
|
|
|
|
BBB
|
BBB@COM
|
Yes
|
yes
|
|
|
|
|
|
CCC
|
CCC@COM
|
Yes
|
yes
|
yes
|
|
|
|
|
DDD
|
DDD@COM
|
Yes
|
|
|
|
|
|
|
EEE
|
EEE@COM
|
|
|
|
Yes
|
yes
|
|
|
FFF
|
FFF@COM
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
Yes
|
|
GGG
|
GGG@COM
|
Yes
|
|
|
|
|
|