topic Re: Send excel attachment through WRS in SAS Web Report Studio

Send excel attachment through WRS

prashant_tomar — Fri, 18 Dec 2015 01:59:10 GMT

Hi,

Plese help how i will send excel attachment using WRS

Thanks,

Prashant Tomar

Re: Send excel attachment through WRS

umeshMahajan — Mon, 04 Jan 2016 13:49:03 GMT

Hi Prashant,

First let me nderstand what you are looking for

1. Do you need Web report to be sent as attachment?

2. Or Do you want when report run excel file should be e-mailed with attachment?

1. this can be done by scheduling report

2. This can be done by calling stored process in web report and which will send email.

this will be stored process with sas code to send email.

Let me know what you are looking for and i can certainly help you on this

Re: Send excel attachment through WRS

prashant_tomar — Wed, 06 Jan 2016 02:04:39 GMT

How I will perform this by stored process

2. This can be done by calling stored process in web report and which will send email.

this will be stored process with sas code to send email.

Re: Send excel attachment through WRS

umeshMahajan — Thu, 07 Jan 2016 17:50:19 GMT

Here is sample code to send attachment via email FILENAME MailBox EMAIL 'Erik.Tilanus@planet.nl' SUBJECT='Mail message with RTF attachment'; FILENAME rtffile 'e:\testlist.rtf'; ODS LISTING CLOSE; ODS RTF FILE=rtffile; DATA _NULL_; FILE PRINT; PUT "This is my report"; RUN; ODS RTF CLOSE; ODS LISTING; DATA _NULL_; attachment=FINFO(FOPEN('rtffile'),'File Name'); FILE MailBox; PUT "attached you find the report"; PUT '!EM_ATTACH!' attachment; RUN; use this code to create sas stored process to create sas stored process follow this http://support.sas.com/resources/papers/proceedings13/148-2013.pdf and to incluse stp in web report studio follow this https://support.sas.com/documentation/cdl/en/citug/61084/HTML/default/viewer.htm#n1j00mg53d0evfn1t08p1muw4nbv.htm and you are done 🙂

Re: Send excel attachment through WRS

prashant_tomar — Fri, 08 Jan 2016 01:28:26 GMT

Report was already creadted in WRS and wana send report with excel attachment

Re: Send excel attachment through WRS

Madelyn_SAS — Thu, 21 Jan 2016 16:53:53 GMT

This topic in the SAS Web Report Studio User's Guide explains your options for exporting to Excel.

http://support.sas.com/documentation/cdl/en/citug/65926/HTML/default/viewer.htm#p1rwzvqm7l9f9dn1hx7wacvtpowd.htm

You cannot directly email a report as an Excel file. You can email a link to a report snapshot, or you can distribute the report as a PDF.