sp_send_dbmail allows you to send emails with attachments. However by default, Database Mail limits file attachments to 1 MB per file.
You can configure database mail to allow larger sizes.
Expand the Management tab, right-click on Database Mail,
Click on Configure Database Mail.
Select "View or change system parameters"
"Maximum File Size (Bytes)" is the option you can change to configure the attachment size.
