There is no upper cap on the size of the attachment, but sending huge files as an attachment is a back practice.
It will lower down the throughput, put extra load on MTA.
Refrain from using this.
For good deliverability and prevent your email from being marked as spam an email size should not be more than 250Kb.
If you have a huge file, place it at a public location and share the link in email.