How to sent response mails to acess

[gserfiotis]

How someone can sent with vba response mail from Οulook to access 2010. The response mails include a standard form with controls (combo box), text box that the center has completed

[jimatqsi]

There's quite a few threads on Bytes about sending emails with Access. Here's some code I just used last week for a client to send an email. They use Outlook 2007 but I'm not sure the code is any different in 2010:

    Set olMail = olApp.CreateItem(olMailItem)
    Dim strSendto As String
    Dim strSubject As String
    Dim strBody As String
    Dim strAttachfile As String
    strAttachfile = pdfPath & PDFFile
 
    With olMail
        .To = Me.EmailAddress_txt
        .Subject = "Account aging report"
        .ReadReceiptRequested = False
        .Body = "Your account aging is attached" ' strBody
        .Attachments.Add strAttachfile
        .Display  ' .send
    End With
 
    Set olApp = Nothing
    Set olMail = Nothing
 

Using .Display brings the email up on the screen in Outlook. Using .Send just sends it.

Jim

[zmbd]

jimatqsi:
That should work so long as the references to the outlook library are set correctly.

gserfiotis:
Your question is just a little vague. Are you wanting to SEND the email or RECEIVE and process the email?

How I read this, you want to send a MS Access form via email and that you would like for the form to function within Outlook, that is not normally possible; however, you can create HTML email forms or InfoPath forms to send out for users to fill out. Pulling the data can be somewhat of a pain. In V2007 there is an automated means of doing this; however, unless both you and your receipents have InfoPath, the wizard is, (IMHO), very poorly implemented.
Biggest issue with the HTML email - conversion to plain text.
Outlook 2010 will do this conversion automatically in a default setup. If you sent a HTML email to me, it would be stripped down to plain text both at work and at home as I do not allow HTML emails to be sent as a security precaution. I've fixed one too many a friend's PC due to virus infections from such emails.

You may also wish to read:

• Microsoft Access / VBA Insights Sitemap
• 163. Application Automation