topic Re: E-Mail Attachment Issues With OneDrive in SAS Programming

E-Mail Attachment Issues With OneDrive

JayS — Wed, 07 Sep 2022 17:05:47 GMT

SAS EG: 7.15 HF7 (7.100.5.6177) (32-bit)

Having issues coding several *.xlsx files located on my laptop for attachment to a SAS generated email using EG, we have migrated to Office 365.

Any advice on how to have the SAS Code identify and attach the file to the Email?

/* Lets Try These Off Of My Laptop */
Attach = 'C:\Users\xxxx\OneDrive - xxxx\Documents\Tableau_9\MasterInventory\FilesForMailing\Acctname_MatchStatus.xlsx'

SAS Log ERROR Below:

NOTE: The file MYMAIL is:
E-Mail Access Device

ERROR: Error opening attachment file C:\Users\xxxx\OneDrive - xxxx\Documents\Tableau_9\MasterInventory\FilesForMailing\Acctname_MatchStatus.xlsx.

Looks like SAS is looking for the files on the bolded location string below.

ERROR: Physical file does not exist, /sasconfig/ADHOC/SAS94/Lev4/SASApp/C:\Users\xxxx\OneDrive -
xxxx\Documents\Tableau_9\MasterInventory\FilesForMailing\Acctname_MatchStatus.xlsx.
NOTE: The SAS System stopped processing this step because of errors.

Thanks in advance for any help.

Re: E-Mail Attachment Issues With OneDrive

ballardw — Wed, 07 Sep 2022 17:14:01 GMT

The /sasconfig/ADHOC/SAS94/Lev4/SASApp/ indicate that SAS is looking on the SERVER running SAS, not your local computer. Your server does not see or have access to your local drive (i.e. C: ) that you are attempting to use. You will need to place the files in a location that the server sees. That may mean uploading them to the server or placing them in another location that you and the server share.

Talk to your SAS admin about options for where the data might reside.

Re: E-Mail Attachment Issues With OneDrive

JayS — Wed, 07 Sep 2022 17:26:36 GMT

Ah, makes sense... Thanks...