topic Re: Duplicate table in email letter in attachment as PDF in ODS and Base Reporting

Duplicate table in email letter in attachment as PDF

DavidBesaev — Wed, 15 Aug 2018 14:54:46 GMT

Hi everyone!

How can I duplicate my few reports (proc report) in email body and like attachment pdf? mayby you know some examples? I find only like attachment or in body messege, bot not both together.

Thx for help!

Re: Duplicate table in email letter in attachment as PDF

Patrick — Fri, 17 Aug 2018 10:23:13 GMT

@DavidBesaev

My general rule of thumb is: It shouldn't take me longer to answer a question than it should take you to formulate the question.

So yes, such things can be done. I'd question though why would you want to do this. ODS allows you to write output to multiple output destinations. ....and now I've spent already more time answering your question than you spent asking the question so I'm stopping right here.

Re: Duplicate table in email letter in attachment as PDF

DavidBesaev — Fri, 17 Aug 2018 11:26:02 GMT

@Patrick Thank you for answer! Good rule 🙂
One more little question: is it done on the date step?

How to put this doc (or pdf) file in the body of the letter in this case, if possible?

Like example:

data _null_;

file outmail to="wenjie_wang@merck.com"

subject="Sales Report"

attach="c:\reports\Sales Report.doc";

put 'Dear team,';

run;

Re: Duplicate table in email letter in attachment as PDF

Patrick — Sat, 18 Aug 2018 00:16:00 GMT

@DavidBesaev

Now I understand what you're trying to do. Have the attachment directly in the body of your mail.

As far as I understand things this is only possible with RTF formatted emails and the "attachment" is actually no more a real email attachment defined via the attachment directive but it's an embedded object in RTF.

So to get to this you would need to create such an RTF formatted message. You'll find docu and whitepapers how to generate and send RTF formatted emails but I haven't found any example for also embedding objects. I'd assume it can be done but will need a bit of work.

Playing around in Outlook I haven't been able to have the exactly same pdf both within the body of the message and in the attachment line - so that's eventually something which can't work at all using Outlook.

Your call if you want to spend the time for this. I probably wouldn't bother and just attach the file.

Re: Duplicate table in email letter in attachment as PDF

DavidBesaev — Tue, 21 Aug 2018 15:05:22 GMT

@Patrick Not quite, I need like at pic. below. I need it because not all devices correctly display the report in the letter and there is a need to duplicate in the PDF format. Thx for helping!