PDA

View Full Version : Download attachments from outlook folders.



abhay_547
10-30-2010, 05:08 AM
Hi All,

I have found 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 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


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


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



Thanks a lot for your help in advance.

Simon Lloyd
11-06-2010, 10:00 AM
abhay, you are not new to forum posting and should be aware of the rules around crossposting, please post ALL links to ALL your crossposts of this question.

abhay_547
11-06-2010, 10:36 AM
Hi Simon,

Apologies, Here are all the links.

http://www.excelforum.com/excel-programming/749955-excel-macro-to-download-attachments-from-multiple-sub-folders-of-outlook.html

http://www.mrexcel.com/forum/showthread.php?t=502933

http://www.thecodecage.com/forumz/members-excel-vba-programming/208104-excel-macro-download-attachments-outlook-folders.html#post741725

Simon Lloyd
11-06-2010, 10:39 AM
Wrong answer!!!
Crossposted here:
http://www.vbforums.com/showthread.php?t=630815
http://www.ozgrid.com/forum/showthread.php?t=147569&page=1
http://www.mrexcel.com/forum/showthread.php?p=2496897

http://www.thecodecage.com/forumz/members-excel-vba-programming/208104-excel-macro-download-attachments-outlook-folders.html
http://www.excelforum.com/excel-programming/749955-excel-macro-to-download-attachments-from-multiple-sub-folders-of-outlook.html