Advanced outlook trick: help needed!

[Jon C]

I need outlook to automatically move all messages with a particular subject into a network folder.

Easy enough...

Problem: Say I send, they reply, I send, they reply.. and multiple versions of the same message are created and dropped into this network folder.

I need a some type of trick/methodology to replace the previous message with the most current email in this network folder. while deleting or moving the old messages out of the network folder. .
Submitted using http://www.outlookforums.com

 

[Michael Bauer [MVP - Outlook]]

If the subject is equal, there's nothing to do as an existing file gets
overwritten.

--
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 Fri, 21 Aug 2009 01:34:30 -0400 schrieb Jon C:

I need outlook to automatically move all messages with a particular subject into a network folder.

Easy enough...

Problem: Say I send, they reply, I send, they reply.. and multiple

versions of the same message are created and dropped into this network
folder.

I need a some type of trick/methodology to replace the previous message

with the most current email in this network folder. while deleting or moving
the old messages out of the network folder. .

 

[Wilfried]

If the subject is equal, there's nothing to do as an existing file gets
overwritten.

Overwriting an existing file can be avoided by testing its existence

Dim myFID As String
Set myFS = CreateObject("Scripting.FileSystemObject")
...
myFID = ...
...
If myFS.FileExists(myFID) ...

but how can "the most current email" be detected?

Wilfried

 

[Michael Bauer [MVP - Outlook]]

Sort the Items collection by ReceivedTime.

--
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 Fri, 21 Aug 2009 13:15:42 +0200 schrieb Wilfried: