![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
I'm trying to set up a macro that when run, allows me to see the size of all
folders in Outlook. I am using the set of code below but I can not get it to work. I open the VBE and have the code exactly how it is shown below. Is there something that I have missed. I would also like to have a popup box with management recomenedations appear in the box. Is this possible? I have next to no VBA experience and that is by biggest problem...so speak slowly...I'm afraid I might not understand. Sorry to keep bothering people with this, but if I can get it to fly, this will be very helpful. Private Sub GetFolderSizes() Dim objOutlook As Outlook.Application Dim objNS As Outlook.NameSpace Dim objFolder As Outlook.MAPIFolder, objUnknown As Object Dim lngBytes As Long, intX As Integer Set objOutlook = New Outlook.Application Set objNS = objOutlook.GetNamespace("MAPI") Set objFolder = objNS.GetDefaultFolder(olFolderInbox) For intX = 1 To objFolder.Items.Count lngBytes = lngBytes + objFolder.Items.Item(intX).Size Next MsgBox "Folder size is " & lngBytes & " bytes." End Sub Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change outlook 2003 notes to a sub folder view | Jeffk3 | Outlook - Using Contacts | 1 | May 4th 06 08:16 AM |
create macro to show file size in outlook | john mcmichael | Outlook and VBA | 3 | May 2nd 06 10:55 PM |
Display size on Detailed Address View | Shayna Punim | Outlook - Using Contacts | 1 | May 1st 06 01:07 AM |
OE folder size limitation? | Bill H. | Outlook Express | 2 | February 23rd 06 07:52 AM |
View free/busy not consisten in folder/schedule view & Exclusive l | Toà n | Outlook - Calandaring | 0 | February 9th 06 03:20 PM |