04-27-2017 10:20 AM - edited 04-27-2017 10:21 AM
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;
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 'firstname.lastname@example.org' 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:
04-27-2017 10:30 AM
I'd use ODS HTML to create the complete body of the email (including tables and free text).
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.