Could anyone point me in the right direction for the following...

I am trying to setup a HTTP interface where the users could enter in their
email address, and could recieve a monthly "newsletter" sent from an email
server, also an email "message" would be sent to them on a certain day they
would input (birthday, etc). What would be the best config for this?
Apache with Sendmail? What exactly is the term for this? What kind of
database to setup?

I am running RHL 9 now with DSL line with Static IP(s). Thanks for any
suggestions you can offer.