Results as a part of Email body- Not as attachment

sreeparna93 · Posted 04-27-2017 10:20 AM

Hi

I want to add a dataset in table format in the email body as well as add text to format the email.

right now I am only add the dataset and unable to add texts.

result.html has the dataset output in html format

The code is below:

FILENAME Mailbox EMAIL "&email"
Subject='Test Mail message'
content_type="text/html";

DATA _NULL_;

FILE Mailbox;
infile "/home/sm25967/DQ_2/QVCDE_QC_Report/result.html";
input;
RUN;
filename Mailbox clear;

RW9 · Posted 04-27-2017 10:22 AM

There was a similar question earlier today, my response was:

A good way to data into an email is to put it out from a dataset:

filename mailbox email 'someone@world.com'
  subject='Total Sales';
data _null_;
  file mailbox;
  set your_data;
  if _n_=1 then do;
    put "Hello";
    put "This is a the Total Sales";
  end;
  put _all_;
run;
filename mailbox clear;

You can find further examples, such as attaching reports, here:

http://www2.sas.com/proceedings/forum2008/038-2008.pdf

Kurt_Bremser · Posted 04-27-2017 10:30 AM

I'd use ODS HTML to create the complete body of the email (including tables and free text).

Then do

data _null_;
file Mailbox;
infile "/home/sm25967/DQ_2/QVCDE_QC_Report/result.html";
input;
put _infile_;
run;

That way your whole mail body is formatted as HTML, and the mail agents will understand that because the mail body starts with a <HTML> tag.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Results as a part of Email body- Not as attachment

Re: Results as a part of Email body- Not as attachment

Re: Results as a part of Email body- Not as attachment

Results as a part of Email body- Not as attachment

Re: Results as a part of Email body- Not as attachment

Re: Results as a part of Email body- Not as attachment

Click image to register for webinar

Classroom Training Available!