topic Re: Send extract as an excel via email in New SAS User

Send extract as an excel via email

new_sas_user_4 — Thu, 27 Sep 2018 16:20:17 GMT

I have an extract from SAS - List.

I can export it as a step in Project and it can be saved on my desktop or C: drive.(I use .xlsx format to do this)

However, what I want to do is send it as an excel attachment to an email address.

Can this be done?

Thanks !!

Re: Send extract as an excel via email

ChrisHemedinger — Thu, 27 Sep 2018 16:31:49 GMT

Is this in SAS Enterprise Guide? You can do this with two steps:

First, Export Data as a Step, saving the XLSX file in your local machine or remote SAS session
Then, select the XLSX file (which will be added to your project) and use Send Email as a Step, which will make this part of your process flow

Before you can Send Email as a step, you will need to configure the SMTP e-mail options in Tools->Options, Administration. You'll need your SMTP server name, port, and any other credentials. A little bit more about that in this article.

Re: Send extract as an excel via email

new_sas_user_4 — Thu, 27 Sep 2018 16:39:50 GMT

Thanks for the response!

The article you shared has information to setup gmail account.

How can I setup my outlook email for this process?

This extract needs to be sent via official email id

Thanks:)

Re: Send extract as an excel via email

ChrisHemedinger — Thu, 27 Sep 2018 16:53:09 GMT

Alas, you cannot use your Outlook client with this step. Sending e-mail via Outlook uses the MAPI protocol (not SMTP), and automating this is usually not permitted for security reasons.

However, if you have Office 365, you should be able to use an approach similar to the Gmail instructions, but applying the O365 settings. See this article (Microsoft) for guidance about what those settings should be.

Re: Send extract as an excel via email

new_sas_user_4 — Thu, 27 Sep 2018 19:45:23 GMT

Thanks!

But we dont use office 365