DATA Step, Macro, Functions and more

Excel attachment around 10MB -- SAS batch process not sending email

Reply
Contributor
Posts: 40

Excel attachment around 10MB -- SAS batch process not sending email

WARNING: Email: 552 5.3.4 Error: message file too big

 

I am getting this WARNING in the SAS log in one of the batch processes. This has 2 excel file attachment -- one is 9MB size and the other one is 100KB size. I don't want to reduce the file size, as most of them are required. When I changed it to CSV, the size is almost doubled, so it is not an option. Right now it uses proc export to xlsx file and then attach via filename email statements.

 

The program abends due to this issue and does not send any emails. I had to manually run from EG and it works fine from EG.

Can anyone suggest a work around for this without removing columns in excel file?

 

I am looking for options where you tell SAS to ignore these warning or use larger than 10MB file size, but could not able to find one.

 

Thanks.

 

 

Super User
Posts: 3,100

Re: Excel attachment around 10MB -- SAS batch process not sending email

[ Edited ]

This is a restriction of your email system - nothing to do with SAS - it is just returning the error from your email system. You could try zipping the attachment first.

Contributor
Posts: 40

Re: Excel attachment around 10MB -- SAS batch process not sending email

Thanks, I got confused because it works from EG and not via batch process.

Do you think EG uses local Outlook and batch job uses email server in SAS grid that restricts the size?

 

I will look into zipping, but do you use x command and gzip or how you would do the zipping other ways?

Super User
Posts: 3,100

Re: Excel attachment around 10MB -- SAS batch process not sending email

I suggest you check with your email admin to find out what your email restrictions are in different environments. If you are emailing within your organisation can you exchange files via a file share or use FTP so you don't have these restrictions?

 

I know some email systems will automatically zip files once they reach a certain size.

Ask a Question
Discussion stats
  • 3 replies
  • 319 views
  • 2 likes
  • 2 in conversation