Avatar billede kasperh Nybegynder
10. maj 2002 - 10:27 Der er 1 løsning

Gemme attachment.

Hejsa,

Hvordan kan jeg via en VBA makro gemme et attachment på en mail i Outlook 2000?

Avatar billede kasperh Nybegynder
10. maj 2002 - 11:33 #1
'**************************************
' Name: Save Outlook Mail Attachment
' Description:This code snippet is actua
'    lly a Macro for Outlook 97, 98 or 2000 b
'    ut can be easily instituted into VB by c
'    reating your Outlook.Application object
'    to completely automate the mod from VB.
'    It could also be used with MAPI mail as
'    well.
' By: Chris Kesler
'
' Inputs:None...
'
' Returns:None... Could be set as a True
'    or False Method for total automation
'
' Assumes:Basic understanding of VBA and
'    VB as well as Office Automation through
'    VB.
'
' Side Effects:None so far...
'
'This code is copyrighted and has' limited warranties.Please see http://w
'    ww.Planet-Source-Code.com/xq/ASP/txtCode
'    Id.27911/lngWId.1/qx/vb/scripts/ShowCode
'    .htm'for details.'**************************************



Sub SaveAttachment()
    Dim oApp As Application
    Dim oNS As NameSpace
    Dim oMsg As Object
    Dim oAttachments As Outlook.Attachments
    Dim strControl
    Set oApp = New Outlook.Application
    Set oNS = oApp.GetNamespace("MAPI")
    'Set folder to check the INBOX
    Set oFolder = oNS.GetDefaultFolder(olFolderInbox)
    strControl = 0
   


    For Each oMsg In oFolder.Items


        With oMsg
            'Check for new mail (unread=true)


            If .UnRead Then
                'This could use the .Subject as well to
                '    search for text in the subject line.


                If InStr(1, .Body, "Body Text To look for") > 0 Then
                    oMsg.Attachments.Item(1).SaveAsFile "Your Drive:\Your Path\" _
                    & oMsg.Attachments.Item(1).DisplayName
                    'Set mailItem to unread
                    .UnRead = False
                    Exit Sub
                End If
            End If
        End With
    Next
End Sub
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester