Email with fields from form

[matthewnsarah07]

Still needing some help with this one!

I'm sure this type of question has been answered before but I haven't found quite the right one.

I have currently got staff annual leave requests on a database. Once their request is accepted we have to send an email informin them.

I would like to (in the easiest way possible) have a button on the form that creates an outlook email which uses the Staff Name filed for the To
And the details of their request etc Date To, Date From in the body of the message.

I'm a total novice with VBA so be gentle if it requires code.

Thanks for your help

 

[Dungmitten]

I don't know if this is any use or it may just be a starter but I did something similar:

DoCmd.SendObject , , , "me@email.com ", Me![StaffnameField] & "", , "Email response to: " & Me![StaffNameField] & "", "Your request has been assessed and authorised. ", True