Query to search for an existing email profile in SQL & send an email using it

Send_Email.sql

--Find a prexisting email profile to be inserted into the "@profile_name" variable below
EXEC msdb.dbo.sysmail_help_profile_sp;
--Define the text you will email
DECLARE @body NVARCHAR(MAX)
SET @body = 'Whatever you want to send yourself'
--Send the email using the email profile found
EXEC msdb.dbo.sp_send_dbmail
    @profile_name = 'Administrator Profile',
    @recipients = 'administrator@youremail.com',
    @body = @body,
    @subject = 'Test Email';