Access: How do I send data from a form using outlook

[crystalgal]

I have a form called CSR
The data in the form is from a query. Within the form I have the following fields:
ProjectName, Job Status, and CSR_Deliver which is a drop down list of names.

I want to be able to select a name from the "CSR_Deliver" list click a commandbutton and the information for that record be copied to the body of the email. Using Outlook.

I want the "ProjectName" field as the subject
I want the "Job Status" and "CSR_Deliver" in the body.

Please help

[pks00]

What about something simple like this, say u had a btn called cmdSend

public sub cmdSend_Click
 
    Dim sBody as String
 
    On Error Resume Next
 
    sBody = "Job Status: " & Me.Job_Status & vbcrlf & "CSR Deliver:" & Me.CSR_Deliver
    DoCmd.SendObject acSendNoObject, , acFormatRTF, , , , Me.ProjectName, sBody, True
End sub