I Have Excel nearly one lakh rows data and same time i will zip via send in smtp mail message activity throw an error mail size is exceed i will send a mail to customer its any Passibility.
Number of rows in the file can’t define the size of the excel alone so look for the file size allowed by your SMTP server and try splitting the file with the size allowed. You can’t really send the bigger file thank allowed by your SMTP server.
SMTP has attachment size limits, so sending one lakh rows in a zipped Excel file will fail.
You can’t send it in a single mail.
you can try this below options:
- split the Excel into smaller files and send multiple emails
- upload the file to OneDrive, SharePoint, or any shared location and send the link
- reduce file size by saving as CSV or removing extra columns
mail object will have a limitation on the size of the attachment. its 25MB max size, no matter what kind of file you try to attach.
Check the size of the zip file that you are attaching to the mail.
SG.
SMTP cannot send very large attachments; the mail size limit is controlled by the mail server.
the only practical solution is to upload the file to a shared location and send the link, or split the excel into smaller parts before sending.
If helpful, mark as solution. Happy automation with UiPath
Its an smtp limitation
You can try to upload to sharepoint or drive and send the link in email …that way you can avoid the file size limits
Cheers