send email from form

[rlambkin]

Hi

I have done a few searches , but cannot find what i am after, unfortuantely, my knowledge of access is not good enough to allow me edit the bits of code i have found.

Basically, I have a form with contact details on it, which include an email address. I want to put a command button next to the email field so that when people click on it an email is sent to that address. HOwever, I want the person to be able to choose between a list of alternative templates on which to base their email. The subject and message text would be held in another table.

Does anyone have any ideas?

Cheers

Rob

 

[Hayley Baxter]

Have a look at this thread and download the first example. This will show you how to open an email in outlook for the current record. Not sure about you templates but this should give you a start. What were you hoping to do with the templates, perhaps a dropdown box to select from that would then take this to outlook along with the correct email address? A little more info might help.

Email Example