Posts by abhay_5472

abhay_5472 · Nov 6th 2010

Re: Excel macro - Downloading attachments from outlook folders

Thanks Simon.

abhay_5472 · Nov 2nd 2010

Re: Excel macro - Downloading attachments from outlook folders

Hi All,

Did any one get the chance to look into the above thread.?

Thanks a lot for your help in advance.:)

abhay_5472 · Oct 31st 2010

Hi All,

I have a code which helps me to downloads only the files with specific extensions like xls, xlsx, ppt etc from outlook, Earlier it use to download all attachments but still I have following issues which are still outstanding and I need help for fixing this issues.

1) Download the files from multiple subfolders .i.e. select the folder in tree view and use that selection in main macro to download attachments.
2) Download only the latest files.

I have selected the true for checkboxes in the property window of treeview1 so that we can select the multiple folders.

I also got the below code to get the selected folders of outlook as selection for downloading the attachments from them. I need help to incorporate this so that we can fix the issue no.1

Code

Private Sub TreeView1_NodeCheck(ByVal Node As MSComctlLib.Node) 
    Dim n As Node 
     
    If Node.Parent Is Nothing Then 
        Set n = Node.Child 
        Do Until n Is Nothing 
            n.Checked = Node.Checked 
            Set n = n.Next 
        Loop 
    End If 
End Sub

Display More

I am attaching my updated macro file for your reference. please have a look.

Thanks a lot for your help in advance.:)