Indhold og vedhæftede filer fra e-mails til Access

This isnt as easy as it may sound.
First you need to read save all attachments to files and then raed the file into the database which isnt a good idea. Attachments can fill quite a lot and putting them into the dB will fill your dB. An idea would be to only save the path/filename.

Tak for forslaget, Terry. Har du et forslag til hvordan man kan indlæse mail-INDHOLD (mail body) ind i Access?

Maybe you can use this
This IS only an example, you also 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 to save the attachments you could try this link
http://www.eksperten.dk/spm/288808

Hej Terry,

Tak for dit svar! Jeg vil prøve dette.

... fik du dine points, Terry?

No I havent received the points yet. You need to accpet my name in the list of users who have placed an answer. I dont think it always works as it should.

Jeg tror du har fået dem nu :-)

Yes, thanks a lot :o)