File size limit for email (SMTP) transfer of Scheduled Excel Reports from 800xA 6.0.3.2
I have setup scheduled excel reports in 800xA and want to send completed reports via e-mail SMTP relay server.
The reports are successfully generated (Completed) in 800xA and stored in File Viewer Aspects.
I have tested the Email function without attachment and it works well i.e by selecting Action Aspect > Email Set > Attachment Format = "None" from dropdown list. Thus i am sure my SMTP is configured correct and no problems with it.
Next when i try to add attachment to email, i.e by selecting Action Aspect > Email Set > Attachment Format = "Excel (xlsx)" from dropdown list then the email sending fails with error code as shown in screenshot attached.
Please let me know the following:
1) If this file size setting is a configuration to be done in 800xA or on SMTP relay server or in Outlook of the recipient ?
2) In any of the above, how to increase the file size of attachment being transferred via email ?
Thanks in Advance..!!

The reports are successfully generated (Completed) in 800xA and stored in File Viewer Aspects.
I have tested the Email function without attachment and it works well i.e by selecting Action Aspect > Email Set > Attachment Format = "None" from dropdown list. Thus i am sure my SMTP is configured correct and no problems with it.
Next when i try to add attachment to email, i.e by selecting Action Aspect > Email Set > Attachment Format = "Excel (xlsx)" from dropdown list then the email sending fails with error code as shown in screenshot attached.
Please let me know the following:
1) If this file size setting is a configuration to be done in 800xA or on SMTP relay server or in Outlook of the recipient ?
2) In any of the above, how to increase the file size of attachment being transferred via email ?
Thanks in Advance..!!

Voted best answer
This is a problem with your SMTP relay server. Google is your friend. There are many possible reasons.
If you need to send the Excel file in .xlsx format, then ensure the original workbook size is as small as possible by removing blank sheets and un-used VBA modules and code. Otherwise, print the report to PDF ( need a soft PDF printer installed ) and send that.
If you need to send the Excel file in .xlsx format, then ensure the original workbook size is as small as possible by removing blank sheets and un-used VBA modules and code. Otherwise, print the report to PDF ( need a soft PDF printer installed ) and send that.
Answers
As a general rule mail size do not exceed 100 MByte.
Please note :
Due the base64 encoding the mail size will be one third bigger, as the file size.
Plus some extra bytes for MIME-headers
Please note :
Due the base64 encoding the mail size will be one third bigger, as the file size.
Plus some extra bytes for MIME-headers
On the SMTP server, there was a file size limit of 2MB set for the attachments transmitted through email. That limit was raised to 4MB and SMTP server was rebooted. This resolved the issue.
Although the file size being transmitted was only 1MB, as suggested by user Hans-Ulli.Kroll above, maybe there were some additional bytes added due to encoding etc which increased the size and exceeded the limit set in SMTP server.
Regards,
Karthik.N

Although the file size being transmitted was only 1MB, as suggested by user Hans-Ulli.Kroll above, maybe there were some additional bytes added due to encoding etc which increased the size and exceeded the limit set in SMTP server.
Regards,
Karthik.N

Add new comment