CREATE TRIGGER
[dbo].[SendEmail_WebContact] on [dbo].[WebContact]
AFTER INSERT AS

DECLARE @firstname      VARCHAR(50),
        @lastname       VARCHAR(50),
        @phonenumber    VARCHAR(10),
        @rdesc          VARCHAR(500),
        @body1          VARCHAR(MAX);

SELECT
    @firstname      = FirstName,
    @lastname       = LastName,
    @phonenumber    = PhoneNumber,
    @rdesc          = RequestDescription
FROM INSERTED;

SET @body1 = 'Name: ' + @firstname + ' ' + @lastname + CHAR(13)
                + 'Phone number:   ' + @phonenumber + CHAR(13)
                + 'Description:   ' + @rdesc + CHAR(13);

  EXEC msdb.dbo.sp_send_dbmail
    @recipients = 'myself@mycompany.com',
    @subject    = 'New Web Contact Request',
    @body       = @body1;

SET @body1 = 'Name: ' + isnull(@firstname,'') + ' ' + isnull(@lastname,'') + CHAR(13)
                + 'Phone number:   ' + isnull(@phonenumber,'') + CHAR(13)
                + 'Description:   ' + isnull(@rdesc,'') + CHAR(13);

CREATE TRIGGER [dbo].[SendEmail_WebContact]
ON [dbo].[WebContact]
AFTER INSERT
AS
BEGIN
  SET NOCOUNT ON;

    -- Get results into a temp table 1st
CREATE TABLE #Mail_Temp (
ID          INT IDENTITY(1,1),
FirstName   VARCHAR(50),
LastName    VARCHAR(50),
PhoneNumber VARCHAR(10),
rdesc       VARCHAR(500)
)

INSERT INTO #Mail_Temp (FirstName,LastName,PhoneNumber,rdesc )
SELECT FirstName,LastName,PhoneNumber,RequestDescription  FROM inserted


DECLARE @firstname      VARCHAR(50),
        @lastname       VARCHAR(50),
        @phonenumber    VARCHAR(10),
        @rdesc          VARCHAR(500),
        @body1          VARCHAR(MAX),
        @ID             INT;


-- Now Loop through your temp table and send emails to induviduals

WHILE EXISTS (SELECT * FROM #Mail_Temp)
     BEGIN

       -- Select only 1 record using TOP clause
        SELECT TOP 1
            @ID             = ID,
            @firstname      = FirstName,
            @lastname       = LastName,
            @phonenumber    = PhoneNumber,
            @rdesc          = rdesc
        FROM #Mail_Temp;


        -- Set email Body
         SET @body1 = 'Name: ' + COALESCE(@firstname,'') + ' ' + COALESCE(@lastname, '') + CHAR(13)
                    + 'Phone number:   ' + COALESCE(@phonenumber, '') + CHAR(13)
                    + 'Description:   ' + COALESCE(@rdesc, '') + CHAR(13);

         EXECUTE msdb.dbo.sp_send_dbmail
                                    @recipients = 'myself@mycompany.com',
                                    @subject    = 'New Web Contact Request',
                                    @body       = @body1;

      -- Delete the record from temp table enventualy to break the loop
       DELETE FROM #Mail_Temp WHERE ID = @ID

     END
END