MS Access and Outlook

[joolsUK0575]

Hi there

I have a bit of brain teaser.

Is it possible to transfer text/ data from MS Access columns in to an email message.

Basically what I ideally would like to do is the following:

1) Have a column that has an email address in it and transfer that in to the "To:, CC: or BCC:" of an email.

2) Be able to transfer data from one of the columns in MS Access to the subject of the email

and

3) Be able to transfer data from column/ s in to the body of the text.

Any ideas??????

Thanks

Jools