CREATE TRIGGER new_contact
ON contacts
FOR INSERT
AS
declare @contact_id varchar(11)
declare @body varchar(2000) 
declare @staff_issued varchar(10)
 
SELECT @contact_id = contact_id,
@staff_issued = staff_issued
FROM contacts
  
SET @body = 'Customer with ID:' + @conatct_id + ' has been created by: '  + @staff_issued 
 
EXEC msdb.dbo.sp_send_dbmail 
@recipients = 'myemail@email.com',
@subject = 'New Customer',
@body = @body
 
GO

INSERT INTO contacts
                      (contact_id, date_issued, staff_issued)
VALUES     ('ABC12345678', GETDATE(), 'ADMIN')

Far away is close at hand in the images of elsewhere.

Anon.