Advanced outlook trick: help needed!

Status
Not open for further replies.
J

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. .
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
If the subject is equal, there's nothing to do as an existing file gets

overwritten.

Best regards

Michael Bauer

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. .
>
 
W

Wilfried

"Michael Bauer " <mb@mvps.org> wrote:

> 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


> 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. .
> >
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Sort the Items collection by ReceivedTime.

Best regards

Michael Bauer

Am Fri, 21 Aug 2009 13:15:42 +0200 schrieb Wilfried:


> "Michael Bauer " <mb@mvps.org> wrote:
>

>> 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
>
> > 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. .
> >>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
mll persistently customise columns in outlook advanced search Using Outlook 3
R Outlook for Mac - Advanced Search and Tracking Sent Emails Using Outlook 0
B Advanced Search in MS Outlook by VBA and SQL Outlook VBA and Custom Forms 2
P Outlook Advanced Find Using Outlook 0
N Outlook 2010 crippled Advanced Find, now what? Using Outlook 3
H Outlook 2010 Advanced Find - Menu items missing Using Outlook 1
D Outlook 2010 - Advanced Find - No Status Bar = No Item Count Using Outlook 2
A Outlook Advanced Search Problems...returns with an Error: Argument Outlook VBA and Custom Forms 1
T Outlook 2007 Indexing Options and Advanced Search options disabled Using Outlook 5
D Create advanced search (email) via VBA with LONG QUERY (>1024 char) Outlook VBA and Custom Forms 2
D Advanced e-Mail search on from/to contact group only searches for first 20 contacts in group Using Outlook 0
O Advanced search - can I use booleans Using Outlook 3
M Sorting by Day in Date Column Advanced Filter BCM (Business Contact Manager) 1
L unblocking attachments before sending Office 365 Advanced Protection Using Outlook 0
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
H "Advanced find: column for full folder path? Using Outlook 1
skylark53 Advanced recurrence problem Using Outlook 2
D Advanced Search Question Using Outlook 1
B Printing Advanced Search Output Screen Using Outlook 5
Andrew Hawkins "Advanced Find" Using Outlook 1
A Advanced find query facilty Help please Using Outlook 2
S Advanced Find text field limits Using Outlook 2
C O2010: Using Advanced Find to locate exact queries Using Outlook 3
V Advanced Find - [Today]-3 ? Using Outlook 4
J How to filter by address fragment (e.g. "@domain.com") with advanced find? Using Outlook 2
L How to customize the Advanced Find form Outlook VBA and Custom Forms 1
P Open Advanced Search Dialog Outlook VBA and Custom Forms 1
D Re: How to customize the Advanced Find form Outlook VBA and Custom Forms 1
S Programmatically bring up Advanced Find for contacts? Outlook VBA and Custom Forms 1
petunia Outlook tasks module sunsetting? Exchange Server Administration 3
G Save emails as msg file from Outlook Web AddIn (Office JS) Outlook VBA and Custom Forms 1
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 3
U Outlook 2021 not showing contact cards in Searches Using Outlook 2
C Outlook - Macro to block senders domain - Macro Fix Outlook VBA and Custom Forms 2
H Outlook 365 O365 outlook calendar item editing Using Outlook 1
J Outlook 365 html inline images Using Outlook 1
Rupert Dragwater How to get Outlook 365 to open from websites Using Outlook 5
S Why do I have to close and reopen Outlook for macros to work? Outlook VBA and Custom Forms 2
J Outlook 2021 ScanPST errors (yet again ... sorry): repair button missing Outlook 2021 Using Outlook 0
HarvMan Outlook 365 - Rule to Move an Incoming Message to Another Folder Using Outlook 4
K Moved pst to new computer, now Gmail not coming into Outlook Using Outlook 7
S Email Macros to go to a SHARED Outlook mailbox Draft folder...NOT my personal Outlook Draft folder Using Outlook 2
F Running Scripts in Outlook 2021 Using Outlook 0
Nufc1980 Outlook "Please treat this as private label" auto added to some emails - Help. Using Outlook 3
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
V Outlook macros no longer run until VB editor is opened Outlook VBA and Custom Forms 0
R Outlook 365 How to integrate a third-party app with Outlook to track email and sms? Using Outlook 2
e_a_g_l_e_p_i I can't believe what I am seeing when trying to install Outlook 2021 Using Outlook 9
Kika Melo Outlook Calendar deleted appointments not in Deleted Items folder Using Outlook 3
P How to get a QR code for automatic signin with Outlook for iOS Using Outlook 5

Similar threads

Top