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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • crystalgal
    New Member
    • Mar 2007
    • 6

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

    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_Delive r" list click a commandbutton and the information for that record be copied to the body of the email. Using Outlook.

    I want the "ProjectNam e" field as the subject
    I want the "Job Status" and "CSR_Delive r" in the body.

    Please help
  • pks00
    Recognized Expert Contributor
    • Oct 2006
    • 280

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

    Code:
    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

    Comment

    Working...