Help!

Macro to Close Open Messages

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Programming VBA RSS
Next:  unselect cells  
Author Message
Dave
External


Since: Sep 30, 2009
Posts: 2
PostPosted: Wed Sep 30, 2009 6:29 pm    Post subject: Macro to Close Open Messages
Archived from groups: microsoft>public>outlook>program_vba (more info?)
I'd like to write a macro to close any message that I have open. I
would also like the macro to leave open any messages that are being
edited. I can't find a collection or object that contains my open
messages. In Excel there's the workbooks object. Is there something
similar for Outlook? I'm using Outlook 2007.

Thanks for any help.

Dave
Back to top
Michael Bauer [MVP - Outl
External


Since: Aug 04, 2006
Posts: 647
PostPosted: Thu Oct 01, 2009 7:10 am    Post subject: Re: Macro to Close Open Messages [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
See the Inspectors collection.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 30 Sep 2009 18:29:58 -0700 (PDT) schrieb Dave:

> I'd like to write a macro to close any message that I have open. I
> would also like the macro to leave open any messages that are being
> edited. I can't find a collection or object that contains my open
> messages. In Excel there's the workbooks object. Is there something
> similar for Outlook? I'm using Outlook 2007.
>
> Thanks for any help.
>
> Dave
Back to top
Dave
External


Since: Sep 30, 2009
Posts: 2
PostPosted: Thu Oct 01, 2009 10:26 pm    Post subject: Re: Macro to Close Open Messages [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Inspectors collection - thank you!

I have it working mostly now, but I'm having trouble determining if an
inspector is "dirty". I'd like to skip these. How can I determine if
an inspector (mail message) is in the process of being edited? Is
there a property for this?
Back to top
Michael Bauer [MVP - Outl
External


Since: Aug 04, 2006
Posts: 647
PostPosted: Fri Oct 02, 2009 3:10 am    Post subject: Re: Macro to Close Open Messages [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You can check then CurrentItem's Saved property. It's False if a change
hasn't been saved yet.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 1 Oct 2009 22:26:06 -0700 (PDT) schrieb Dave:

> Inspectors collection - thank you!
>
> I have it working mostly now, but I'm having trouble determining if an
> inspector is "dirty". I'd like to skip these. How can I determine if
> an inspector (mail message) is in the process of being edited? Is
> there a property for this?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Programming VBA All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum