Not sure if this goes in this particular forum.

I want to click a button from a form that auto emails particular individuals one at a time to each persons respective information. I do not want it to go out as an attachment though, it needs to be in the body of the email.

what information would you want to send to the user?
what version of access are you using?

Basically equipment that is aged on an individuals truck, would list the serial number and receiver type and days in inventory. 2003 at work and 2007 at home. right now I am at home working on it.

you can search the UA archives where there are plenty of VBA modules for sending email from Access that you might be able to work with.

I had the same issue. First I created a query, then I found and altered VBA code to my specifications.
I used the code from this website: http://www.access-freak.com/blog2008.html#...tryAugust200802

I utilized the function "HtmlNoReportEmail(strTblQryName As String)". Paste the code into a new VBA module, edit it to meet your specifications(change field names in the strmsg section), and reference the function on your form. My email process is button-driven, so for the on click event via my form button, the reference is =HtmlNoReportEmail("myqueryname"). Works like a charm. If the to section needs to be populated from fields within your query or table, add another Dim statement such as DimCustomers as String; Customers = rs.fields("contactfieldname"). And reference "customers" in the the .to segment at the bottom of the code. Hope that helps.