Exporting an E-mail from an Outlook to Access!!

[Johnnyw]

I have an application that is sort of like a help desk that tracks issues. The issues are sent by e-mail and i would like to be able to import the e-mails directly into access without someone manually typing it in. Then the support personnel can view the issues by way of a form to work on the issues and report updates. Is there a way to import e-mail messages into Access? I searched some posts but I don't quite understand. Can someone help??

 

[Atomic Shrimp]

if you have Outlook and Access 2000, then you can link in the Inbox as a table, but you won't get any attachemnts, just the text fields.

if you want to copy attachments automatically on receipt, you need a bit of code like this one:

Private Sub Application_NewMail()

Dim oApp As Outlook.Application
Dim oNameSpace As NameSpace
Dim oFolder As MAPIFolder
Dim oMailItem As Object
Dim sMessage As String
Dim intLoop As Integer

Set oApp = New Outlook.Application
Set oNameSpace = oApp.GetNamespace("MAPI")
Set oFolder = oNameSpace.GetDefaultFolder(olFolderInbox)

For Each oMailItem In oFolder.Items
    With oMailItem
        If oMailItem.UnRead = True Then
            For intLoop = 1 To oMailItem.Attachments.Count
                    oMailItem.Attachments.Item(intLoop).SaveAsFile "C:\AttIn\" & oMailItem.Attachments.Item(intLoop).FileName
            Next intLoop
        End If
    End With
Next oMailItem

Set oMailItem = Nothing
Set oFolder = Nothing
Set oNameSpace = Nothing
Set oApp = Nothing
 
End Sub

(You need to put this code into the NewMail event in the VB editor in Outlook 2000) - this will copy all incoming attachments to a folder called C:\AttIn

[This message has been edited by Mike Gurman (edited 10-03-2001).]

 

[Johnnyw]

Thanks Mike, but I have Access 97 and Outlook 97. Is it the same?

 

[Atomic Shrimp]

No, but there are (I think) add-ins available, I couldn't say how good/easy they are though.

Try a Google search with keywords like Access, Outlook, Integration, email, extract and so on.