how to make something like a newsletter

hi,
i want to make something like a newsletter form.

i want that a registered user can choose an article from the category news in a dropdown maybe (only from news).
then there is a a second dropdown with some email adresses in to choose. and on submit the complete article (text and images (images as attachment)) is send to the selected email adress.

i found something here that was goning in this direction but i didn`t work for me

thx for any help

Hi snow,

all you need is a SQL query to load the article data from the database based on the dropdown selection and load the email template with this, like what we do with the image at submit content! look at the forums here for SQL queries with the word "SELECT"

Cheers
Max

thx for showing me the right direction.