Send excel attachment through WRS

[prashant_tomar]

Hi,

Plese help how i will send excel attachment using WRS

Thanks,

Prashant Tomar

[umeshMahajan]

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

[prashant_tomar]

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.

[umeshMahajan]

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#n1j00mg53d0evfn1t08... and you are done 🙂

[prashant_tomar]

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

[Madelyn_SAS]

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#p1rwzvqm7l9f9dn1hx7w...

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.