Usage Note 18345: "This file is not in a recognizable format" error occurs when you are sending Excel file attachments via SMTP e-mail
In most cases, sending Excel file attachments via SMTP e-mail is not a problem.
However, in some cases, the Excel file resides on the SMTP server itself and MS-Office
or MS-Excel is not installed on the server.
The resulting file attachment becomes corrupt, and the following error message is generated from Excel when you try to open the file:
"This file is not in a recognizable format."
In SAS 9.1 and beyond, this problem can be corrected by using content_type="application/vnd.ms-excel"
as shown in the following example:
filename mymail email from="yourid@email.com"
to=("id1@.emailaddr.com" "id2@emailaddr.com")
subject="Put Subject Here"
attach=("path to file\filename.xls" content_type="application/vnd.ms-excel");
data _null_;
file mymail;
put 'hello world';
run;
quit;
Operating System and Release Information
SAS System | Base SAS | Microsoft Windows 2000 Advanced Server | 8.1 TS1M0 | |
Microsoft Windows NT Workstation | 8.1 TS1M0 | |
Microsoft Windows 2000 Datacenter Server | 8.1 TS1M0 | |
Microsoft Windows 2000 Professional | 8.1 TS1M0 | |
Microsoft Windows 2000 Server | 8.1 TS1M0 | |
Microsoft Windows 95/98 | 8.1 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | |
Topic: | Analytics ==> Transformations SAS Reference ==> Procedures ==> STANDARD
|
Date Modified: | 2007-10-29 14:28:26 |
Date Created: | 2006-08-24 15:38:32 |