topic Re: How to embed a output in email body in SAS Enterprise Guide

How to embed a output in email body

Programmer26 — Wed, 26 May 2021 16:58:37 GMT

Hi all,
I am working on a project where i have to generate an email through sas containing a excel as attachment and a table embedded in the email body.
I am able to add the attachment but unable to embed the output in the email body.

Here is how i am doing it for attachment
Data _null_;
From=
To=
Subject=
Attach=
Content_type ="excel" ;
Email body;
Run;
This is what i am doing right now, need to incorporate the code to add output directly in the email body.
Thank you in advance.

Re: How to embed a output in email body

r_behata — Wed, 26 May 2021 17:17:57 GMT

Try This :

filename myfile
	email
	to=()
	cc=()
	subject=""
	attach=("");

data _null_;
	file myfile;

	if _n_=1 then
		do;
			put ' ';
			put ' <Insert Email Body Here >';
			put ' ';
			put ' Thanks!';
		end;
run;

Re: How to embed a output in email body

Programmer26 — Wed, 26 May 2021 17:26:01 GMT

I am able to send an email with a excel as attachment but the concern is in the other part of the question where i have to add another output which will be embedded directly in the email body like this

Good morning
Please find below top 5 countries :
Col1 col2
A. 123445
B. 1234
C. 123
D. 12
E. 1

Regards
Xyz

Re: How to embed a output in email body

Reeza — Wed, 26 May 2021 17:35:44 GMT

Please remember to search the forums before posting your question.

Or do none of the previously solved questions work for you? If so, please explain how.

https://www.lexjansen.com/mwsug/2010/appdev/MWSUG-2010-89.pdf
https://communities.sas.com/t5/SAS-Enterprise-Guide/Formatting-proc-print-tables-in-email-body-text-to-include-lines/td-p/496613

Images are more complicated
https://communities.sas.com/t5/General-SAS-Programming/Embed-image-png-or-jpeg-in-email-as-body-or-background-not-as/td-p/415267