Outlook VBA automatically download attachment

Hi all,

I receive several files daily and I have a VBA script to download these files to a directory automatically. However, the main concern right now is, the script only runs on the client-side, which means whenever I am on vacation these files would not be downloaded. I cannot leave my computer running during those periods in compliant with the corporate security. 

On the side note, I have a server running 24/7. My question is, is there any software/utility, that I can setup on the server, to have it run at a specific time with a specified credential to download the files and logs out. I don't want my outlook credential to be logged on all the time.

Thanks,

June 28th, 2013 9:59pm

You can save your attachment via VBA rule:

        Sub WykazKodowKontrola(Item As MailItem)
         If Item.Class = olMail Then
         If Item.Attachments.Count > 0 Then
         Dim objAtt As Outlook.Attachments
         Set objAtt = Item.Attachments
         For Each objAttach In objAtt
         objAttach.SaveAsFile "C:\YourFolder\" & _
         Item.subject & "_" & objAttach.FileName '<- Create your folder first and change code
         Next
         Set objAtt = Nothing
         End If
         End If
        End Sub

Course your Outlook should stay turning on.

Free Windows Admin Tool Kit Click here and download it now
June 30th, 2013 3:11pm

Hi Oskar,

The main problem is I dont' want to leave my outlook on for security purposes as it will be left on on the server. Is there any software that can turn outlook on at a specific time with specific credentials?

Thanks,

July 3rd, 2013 1:02pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics