Easiest way to send auto email from Access

[childrenfirst]

Hi,

I have an Access form which contains a text box (txtUserName) a combo boxe (cboDept) and a command button. When users click on the command botton, values in the text and combo boxes will be passed to a SQL table. I would like to add another function into the VBA code (I only know how to do it in SQL mail, not vba), which sends an email automatically with the value of txtUserName and of cboDept in the email body.

Can anyone help me get started with the code since I have no experience in setting auto email in Access?

Thank you very much!

 

[MelissaKT]

There are several threads through this website that have some really nifty ways of handling email. Are you sending the email to a static address? Or is this an email that is based on the record? Check out the docmd.sendobject command - you should be able to build what you need in the "message text" parameter. Let me know if you need some help with it. Or if I'm completely off base here.