How to create and send mail in SQL Server 2008?
In SSMS object Explorer, click Management
Right-click Database Mail
Click Configure Database Mail




4.Select Set up Database Mail by performing the following tasks



5.Enter a profile name and click Add



6.Enter the settings for your email account. I could not set the account for my company's email account - it just didn't work. But I had no trouble with setting the Gmail account I use and these are the parameters that you should use for the Server name and Port number



It is not possible to send attachments from SSMS, you have to use T-SQL for that:

EXEC msdb.dbo.sp_send_dbmail
@profile_name='carol Gmail',
@recipients='john@john.com',
@subject='Test email',
@body='Attachment test',
@file_attachments='D:\123\pic.jpg'