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

meckarthik — Fri, 28 May 2021 10:52:12 GMT

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;

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

Sajid01 — Fri, 28 May 2021 19:10:46 GMT

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.