Send extract as an excel via email

[new_sas_user_4]

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 !!

[ChrisHemedinger · Accepted solution]

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.

[new_sas_user_4]

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:)

[ChrisHemedinger]

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.

[new_sas_user_4]

Thanks!

But we dont use office 365