I believe it should be sent by whomever the super admin is (as set in your cp); the "from" address should be your forum email addy.
As for the message, this is set in the cfrm language file; you can edit your language files from the control panel or via FTP.