Using INSERT INTO Mixing SELECT And Static Text

 I'm trying to populate a table of pending emails. The problem is I need
to populate the email field using a select statement but the message
field with static text. Can this be done or is another approach more
prudent? What I have is below but is kicking errors:

DECLARE @msg varchar(300)


SET @msg = 'New users have applied for accounts. Please review their information.'

IF @Type='CreateUserApply'
INSERT INTO cdds_Email (Address,Message)
VALUES (SELECT
M.Email
FROM
dbo.aspnet_Membership M
INNER JOIN
dbo.aspnet_UsersInRoles U
INNER JOIN
dbo.aspnet_Roles R
ON
U.RoleId = R.RoleId
ON
U.UserId = M.UserId
WHERE
R.RoleName = 'Manager',@msg)