send an email from SAS and attach a file

[Ronein]

Hello

I want to send an email from SAS and attach a file.

I receive an error

ERROR: Error opening attachment file \\path\Report.xlsx.
ERROR: Physical file does not exist, \\path\Report.xlsx.

I check and the path is correct so I cannot understand what is the problem.

How can I check if the problem is with my authorization?

data _null_;
file sendit email
from="XXX@gmail.com"
to=("YYY@gmail.com")
subject="Important Document"
importance="High"
attach=("\\path\Report.xlsx");
put "Please find attached the file";
put;
put "Thanks!";
run;

[Jagadishkatam]

Could you please check the path again. I believe this is not the correct path, could you share the screenshot of the actual path

\\path\Report.xlsx

[Ronein]

The path is 100% correct.

I changed it in the post because I cannot write path of my work

[Patrick]

@Ronein 

Can you read anything from this path via a "normal" libname or filename statement?

Have you by any chance the Excel opened via another application (i.e. via a local MS Excel)?

[Ronein]

Hello

Excel file is not opened

Path is correct (If I go to start and paste the path then i can see the excel file)

[Patrick]

---

@Ronein wrote:

Hello

Excel file is not opened

Path is correct (If I go to start and paste the path then i can see the excel file)

---

I assume you can see the path from your local machine. If SAS isn't installed on your local machine then this doesn't tell you if this path is also correct on the machine where SAS executes - that's why I've asked you if you're able to execute any filename or libname statement using this path. Just try: libname test '\\path'; This will already tell you if the path as such is accessible from the SAS side.