Mail fra Outlook til Access database

Forresten det skulle være en VBA kode som kan eksekveres fra Outlook

I can give you an example of VBA code in Access which takes your mail FROM Outlook!

This IS only an example! and you need a reference to Outlook

Public Function SaveMyMail()

Dim myApp As New Outlook.Application
Dim myNameSpace As Outlook.NameSpace
Dim myFolder As Outlook.MAPIFolder
Dim myMsg As Outlook.MailItem


Set myApp = CreateObject("Outlook.Application")
Set myNameSpace = myApp.GetNamespace("MAPI")
Set myFolder = myNameSpace.GetDefaultFolder(olFolderInbox)

    For Each myMsg In myFolder.Items
        With myMsg

        'There are LOTS of other fields               
            Docmd.runsql "INSERT INTO YourTable (MialBody) VALUES ('" & myMsg.Body & "')"

               
        End With
    Next
   
    Set myFolder = Nothing
    Set myNameSpace = Nothing
    Set myApp = Nothing
   
End Function

and where are we going from here janriis?

helllloooooo!

Hej terry, undskyld jeg havde glemt at jeg havde denne "thread" ude, jeg savner at kunne se på sitet, hvilke threads man har igang. (det kan måske godt, jeg har bare ikke fundet ud af hvor man ser det)

:o)

I have a folder with outsanding questions, otherwise it could be an idea that eksperten used