Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / May 2005

Tip: Looking for answers? Try searching our database.

AutoArchive programmatically

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robert Morley - 26 May 2005 16:33 GMT
Hi everyone,

I've actually got two problems, but I've worked around the second, so let me
present the unsolved one first:

First, I'm looking for a way to programmatically run an auto-archive.  I've
tried hunting around, and I'm damned if I can find anything.  Even if I
triggered the "File", "Archive" menu, that would still pop up a menu, which
sorta defeats the purpose.

Okay, my second problem is that I'm looking for a way to force automatic
processing of receipts.  If you leave Outlook open at the Inbox, it'll
eventually get around to processing some receipts, but it never seems to do
a complete job if you have a lot of them, and in any event, you never know
when it'll "get around to it".

What I'm doing currently, which is definitely a kludge, is to open the
Inbox, scan through each message and if it's a receipt, open it and then
close it again right away, which forces Outlook to process the receipt
immediately.  With sometimes hundreds of receipts to go through, this can be
a little annoying, since you have to wait, pretty much unable to touch
anything as it opens and closes a window for each and every one of them.
I'm convinced there's got to be a better way, preferably one that doesn't
involve any visuals of any kind...can anybody provide any suggestions?

Thanks,
Rob
Eric Legault [MVP - Outlook] - 26 May 2005 17:52 GMT
1) There is no way other than automating the execution of the menu item to
start the AutoArchive process programmatically.

2) Have you tried enabling the "After processsing, move receipts to" setting
under Tracking options?  Otherwise, you can create a rule that moves items
using the Report form (choose "using the form name" rule option, and choose
Report form the Application Forms library), which may work better for you.

Signature

Eric Legault - B.A, MCP, MCSD, Outlook MVP
--
Try Picture Attachments Wizard for Outlook!
http://tinyurl.com/9bby8
--
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

> Hi everyone,
>
[quoted text clipped - 23 lines]
> Thanks,
> Rob
Robert Morley - 26 May 2005 18:23 GMT
To answer your question, yes, I've got the "After processing" option set to
move them to the Deleted Items folder.

The problem isn't getting the receipts to be moved after being processed,
it's getting Outlook to decide that they need to be processed NOW.  It seems
to wait about 10 minutes or so after you've opened Outlook before it starts
a background scan for receipts.  Because I'm just opening Outlook briefly to
process receipts for this particular account, the processing is supposed to
be on-demand and I'd like to have it begin it's processing pass immediately,
not "whenever it feels like it". :)

In any event, I'll try your suggestion about adding a rule and see if that
forces it to process them, but I think maybe I tried that a while ago and it
didn't...it's been a while since I played with it, though, so I'll
double-check.

Thanks,
Rob

> 1) There is no way other than automating the execution of the menu item to
> start the AutoArchive process programmatically.
[quoted text clipped - 39 lines]
>> Thanks,
>> Rob
Robert Morley - 26 May 2005 18:35 GMT
FYI, as expected, using a rule simply moved them to the Deleted Items folder
without processing them properly, regardless of my settings in "Tracking
Options".

Rob

> 1) There is no way other than automating the execution of the menu item to
> start the AutoArchive process programmatically.
[quoted text clipped - 39 lines]
>> Thanks,
>> Rob
Eric Legault [MVP - Outlook] - 26 May 2005 20:12 GMT
According to this article
(http://support.microsoft.com/default.aspx?scid=kb;en-us;197067):

"There must be 30 to 60 seconds of idle time on your computer before the
automatic processing will activate. Any keyboard or mouse movement will
interrupt this idle time"

Signature

Eric Legault - B.A, MCP, MCSD, Outlook MVP
--
Try Picture Attachments Wizard for Outlook!
http://tinyurl.com/9bby8
--
Job: http://www.imaginets.com
Blog: http://blogs.officezealot.com/legault/

> FYI, as expected, using a rule simply moved them to the Deleted Items folder
> without processing them properly, regardless of my settings in "Tracking
[quoted text clipped - 45 lines]
> >> Thanks,
> >> Rob
Robert Morley - 27 May 2005 23:38 GMT
Well, at least that tells me what the criteria are for automatic processing.

Somehow it seems a little gauche to programatically open up an e-mail then
tell the user not to touch their computer for several minutes, since you
don't know exactly when it'll start or how long it'll take to be done.

It may be a kludge, but at least opening and closing each message forces it
to happen right away, and you can add a progress bar based on the number of
messages in the folder.  (Of course, it's a little hard to see the progress
bar with message windows constantly opening over top of it, but hey, what
can you do?)

Now if there was a way to open a message window hidden, that'd be truly
helpful, since it would make my kludge much less kludgey, but it seems you
can't do that with the Inspector.Activate method in Outlook XP (otherwise I
would've).  I can, of course, set the WindowState after activating it, but
since my next statement is Inspector.Close, there's very little point, and
it doesn't get around the fact that it opens visibly anyway.

The article does bring up another possibility, though, which is to delete
the message...I wonder if programmatic deletion of one message at a time
would trigger the logging?  Guess I'll have to try it out.

Rob

> According to this article
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;197067):
[quoted text clipped - 64 lines]
>> >> Thanks,
>> >> Rob
Robert Morley - 28 May 2005 00:27 GMT
Unfortunately, it would seem that the Item.Delete method doesn't cause the
item to be processed, only deleting it from the main Outlook window.  One
wonders if there's some hidden method, or Extended MAPI method that would do
it, but I'm not sure if I want to go to that level.

Rob

> Well, at least that tells me what the criteria are for automatic
> processing.
[quoted text clipped - 95 lines]
>>> >> Thanks,
>>> >> Rob
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.