You can use php code to send message which will trigger email. Use php function fep_send_message to send message. You can get an idea how to use that function in here https://www.shamimsplugins.com/docs/front-end-pm/customization/send-welcome-message-user-register/
We cannot trigger email if you manually input message directly to database.