Command Button

[AmandaS]

I built an access database and now I would like to add a button so that on click it will open up a new template email. I would also like the current record to be included in that email. Please help.

 

[The_Doc_Man]

Search the forum on these topics. (Also the Help files.)

SendObject

Application automation

Creating application object

I don't recall that there is an existing button wizard to do what you want, so you are just about 99.9% sure to need to work in VBA to build the message body and mail distribution list. The good news, if you are using Outlook, is that Outlook help has sample code on how to do that. The bad news would be if you were not using Outlook.