I managed to make the Forms Module Notification work
You can view the designer in the attached image.
I have created a custom designer for the Forms Control in order to add the email addresses to which the form submission will be sent.
The smtp settings will be provided in the system config file.
Special thanks for christine for the base code of this project.
You can download the working control from http://bit.ly/g0vtGX
1- Download the project from the link
2- Add reference to this project from your Sitefinity project
3- Open the Sitefinity administration and go to Administration -> Settings -> Advanced -> Toolboxes -> PageControls -> ContentToolboxSection -> FormsControl and set the settings as follows:
Control type: FormsNotification.FormsControlCustom, FormsNotification
Title: Forms Control
ResourceClassId: clear the textbox
This will replace the default Forms Control with the Custom Forms Control and you are ready to drop it on your pages.
To set the smtp settings Go to Administration -> Settings -> Advanced -> System -> SMTP (Email Settings)
Note: This code has been tested with Sitefinity 4.0 SP 1
Hope you will find this helpful