Sending Email from a form button using text fields to build the email

I have a form that allows you to select a record from a query. It populates a number of text boxes with data from the table. I would like to use a macro attached to a button that will construct the email subject and body and send using HTML rather then plain text in outlook. The send object method does not appear that it will work for this. Occasionally, an attachment needs to be send also, which is stored in the tbl as well.

Any help would be appreciated.

That looks good for Excel, but I am wondering for Microsoft Access.

After much research and trial and error, I was able to figure it here. Code example for anyone interested:

Option Compare Database

Public Sub SendEmailP()
Dim strEmail, strBody, strsubject As String
Dim objOutlook As Outlook.Application
Dim objEmail As Outlook.MailItem

'**creates an instance of Outlook
Set objOutlook = CreateObject("Outlook.application")
Set objEmail = objOutlook.CreateItem(olMailItem)

'**************************************************************
'*create string with email address

strEmail = txtEmail

strBody = [Forms]![navigation]![NavigationSubform].[Form]![EmailVerbiage]
strsubject = [Forms]![navigation]![NavigationSubform].[Form]![EmailSubject]


'***creates and sends email
With objEmail
    .To = "email address here"
    .Subject = strsubject
    .body = strBody
    .Display
End With

Exit Sub


End Sub