Sending Email From SQL Stored Procedure

To Send email from DB server

EXEC msdb.dbo.sp_send_dbmail
 @recipients = 'Group-OTBExternal@softwire.com',
 @body = @lMessage,
 @subject = 'Booking creation check',
 @profile_name = 'localhost'

TODO : Mail Server Settings ?