topic Re: Base SAS 9.3 issue with sending email in SAS Programming

Base SAS 9.3 issue with sending email

Rishadnp — Tue, 18 Sep 2018 15:02:24 GMT

Hello There,

Im getting error message while trying to send email through Base SAS 9.3.
Outlook 2016 is not detecting while trying to send email from sas 9.3 64 bit. MS office outlook is 34 bit.
Appreciate if someone can guide me with a solution

Re: Base SAS 9.3 issue with sending email

Rishadnp — Tue, 18 Sep 2018 15:03:02 GMT

Re: Base SAS 9.3 issue with sending email

sabisw — Tue, 18 Sep 2018 15:19:19 GMT

@RishadnpThis might offer some assistance.

https://support.sas.com/resources/papers/proceedings13/023-2013.pdf

Re: Base SAS 9.3 issue with sending email

Rishadnp — Tue, 18 Sep 2018 15:09:04 GMT

Thank you. let me review and confirm

Re: Base SAS 9.3 issue with sending email

Reeza — Tue, 18 Sep 2018 15:20:17 GMT

@sabisw My edit was to fix the link (had an extra space at the end), no change to your answer.

@rishandnp what error did you receive?

Re: Base SAS 9.3 issue with sending email

Rishadnp — Tue, 18 Sep 2018 15:25:58 GMT

Error mesage is ;
Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.”

My outlook is the default mail client!

Re: Base SAS 9.3 issue with sending email

Reeza — Tue, 18 Sep 2018 15:26:53 GMT

Are you running this in batch or as a stored process? Or on a server installation?

@Rishadnp wrote:
Error mesage is ;
Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.”

My outlook is the default mail client!

Re: Base SAS 9.3 issue with sending email

Rishadnp — Tue, 18 Sep 2018 16:51:08 GMT

Stored process

Re: Base SAS 9.3 issue with sending email

Kurt_Bremser — Tue, 18 Sep 2018 17:01:01 GMT

Stored processes run on a server, and servers often have no typical client software. Make sure that a mail conduit is installed and up on the server, and have it configured into SAS.

Re: Base SAS 9.3 issue with sending email

Rishadnp — Tue, 18 Sep 2018 17:26:30 GMT

Im not sure i understand your advise correctly. Below is the brief of my requirement.

I have master excel files stored in a folder (on my desktop). I use sas codes for sending files to multiple department managers daily . Not sure if this can be categorised as stored process.

Re: Base SAS 9.3 issue with sending email

Reeza — Tue, 18 Sep 2018 19:22:02 GMT

You stated you were running this as a stored process. A stored process is not run locally on your computer. The fact that Outlook is installed on your computer is irrelevant because the process is on the server. So the server must have Outlook or some email client.

A stored process in EG is a very specific task, so you likely would be pretty certain if you're working with a stored process or not.

But I suspect you are working on a server that doesn't have Outlook as indicated. As well, the account that runs the stored process won't be yours and the email account it comes from may be different.

Can you run a test example using the paper referenced and get that to work? I would start by making sure it works at all on your computer and then getting it work specifically for your project.

Post your code and errors if you continue to have issues.

@Rishadnp wrote:
Im not sure i understand your advise correctly. Below is the brief of my requirement.

I have master excel files stored in a folder (on my desktop). I use sas codes for sending files to multiple department managers daily . Not sure if this can be categorised as stored process.