MailItem Object explanation

		Microsoft Office Forums > Microsoft Office > Outlook
MailItem Object explanation

04-01-2020, 08:55 PM

gmayor

Windows 10 MailItem Object explanation

Office 2016

Expert

Join Date: Aug 2014

Posts: 4,144

I don't think you can address ReportItem directly from VBA without third party software so the line should be

Code:

If TypeName(Item) = "MailItem" Then

If Item is classed as Object then this should go directly after For Each e.g.

Code:

For Each Item In olSubFolder.Items
    If TypeName(Item) = "MailItem" Then
        If Item.Attachments.Count > 0 then
           'Do stuff

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Image and it's explanation need to stay together	mohsen.amiri	Drawing and Graphics	2	10-04-2017 04:10 AM
Explanation for this formula	Will	Excel	7	11-26-2014 05:27 PM
Cannot access most of property of MailItem object on Windows Server 2008 64 bit	tz900	Outlook	0	04-10-2012 12:55 PM
Explanation for fields on the form	hklein	Word VBA	5	10-23-2011 04:10 AM
MailItem Inspectors cache CommandBars but Calendar do not?	Hydrogen	Outlook	0	03-04-2006 09:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:13 AM.