View unanswered posts | View active topics It is currently Wed Oct 18, 2017 5:46 am



Reply to topic  [ 2 posts ] 

number of attachments in outlook 2010

Sponsor

Sponsor
 

number of attachments in outlook 2010 
Author Message
amoeba

Joined: Fri Jun 16, 2017 6:33 am
Posts: 1
Post number of attachments in outlook 2010
Hi,

I always receive the emails with several attachments. I hope I can see the number of the attachments in the email list when the email coming. It will save much time for me.

Is there any option in outlook that I can show the number of attachments of emails in email list?


Fri Jun 16, 2017 6:49 am
Profile
amoeba

Joined: Wed Jun 21, 2017 1:59 am
Posts: 1
Post Re: number of attachments in outlook 2010
Hi,

You can write CBA code to count the number of attachments for you, and then create a new rule for running the script on every incoming email. Try the macro below

Code:
Sub AutoCountAttachments(objMail As Outlook.MailItem)
    Dim objAttachments As Outlook.Attachments
    Dim objProperties As Outlook.UserProperties
    Dim objProperty As Outlook.UserProperty
    Dim strPropertyName As String

    Set objAttachments = objMail.Attachments

    strPropertyName = "Attachment Count"
    Set objProperties = objMail.UserProperties

    'Check if there is already a column in this name
    Set objProperty = objProperties.Find(strPropertyName, True)
    If objProperty Is Nothing Then
       'If not, add this column
       Set objProperty = objProperties.Add(strPropertyName, olText, True)
    End If

    'Set the column value equal to the count of attachments
    objProperty.value = objAttachments.Count
    objMail.Save
End Sub


And you can find the detailed steps to create a new rule for running this script at

https://www.datanumen.com/blogs/display-attachment-count-email-list-outlook-vba/

Hope it helps.


Wed Jun 21, 2017 3:07 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
forum administered by Gregg Fishwick