Sending email with xlsx attachment + copying and pasting content from sas table to email body

[meckarthik]

Hi,

I've requirements to send an email with xlsx. attachment along with the need to show the content from another temporary sas table in the email body. 

Currently, the email attachment is working, can we add contents from another sas table to the email body as below? 

Bold lines are to be added 

Say example 

DATA _NULL_;       

FILE OUTBOX;    

PUT %SYSFUNC(COMPBL("Hi ));

PUT ;

PUT %SYSFUNC(COMPBL("The following advertisers have a due to expire in the next 21 days:  &Client_Name.."));

PUT ;

"Adding list from the temp sas table 

Firstname Familyname address

"

PUT %SYSFUNC(COMPBL("Please ask the clients to remove the tags from their website before this date."));

PUT ;

PUT %SYSFUNC(COMPBL("Full list of Advertisers and their expiry date is attached."));

PUT ;

PUT %SYSFUNC(COMPBL("Thanks"));

run;

FILENAME OUTBOX CLEAR;

[Sajid01]

Add the following statements.

1.set mydataset ; /*after data _null_;*/

2.put @1 var1 @10 var ; /* this is an example. Add where bold lines are*/

Then you should be good to go.