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. .
 
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. .
>
 
"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. .
> >
 
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.
< Issue with detecting changes in a folder. Outlook 2003. | Date Stamp in SUBJECT BOX of Outgoing/Incoming Mail >
Similar threads
Thread starter Title Forum Replies Date
S Related messages show in main Outlook window vice new Advanced Find windows Using Outlook 1
farrissf Outlook 2016 Optimizing Email Searches in Outlook 2016: Seeking Insights on Quick Search vs Advanced Search Features Using Outlook 0
C Advanced search terms for "Outlook Data File" Using Outlook 1
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
e_a_g_l_e_p_i Question about Outlook 2021 and Gmail Using Outlook 2
J Outlook VBA to send from Non-default Account & Data Files Outlook VBA and Custom Forms 2
P Limited Support for 3rd Party Mail in new Outlook? Using Outlook 1
O Any 3rd party tool that sync (mirror) from Outlook Calendar to Google Calendar? Using Outlook 5
T Outlook is categorizing emails incorrectly Using Outlook 1
R Legacy Outlook on Mac Email Cache Using Outlook 0
A Outlook can't remember outlook.com, Exchange password. Using Outlook 3
H Force Outlook 2019 with GMail 2-Step to Require Login? Using Outlook 0
G Retaining Tabs in outlook body Using Outlook 2
V Setting up Outlook 2021 on new computer Using Outlook 2
G Add Map It button to Custom Contacts Form in Outlook Outlook VBA and Custom Forms 1
X Custom icon (not from Office 365) for a macro in Outlook Outlook VBA and Custom Forms 1
Victor_50 Problem - Google Workspace will stop "unsafe" access to Outlook end 2024 Using Outlook 3
C New pc, new outlook, is it possible to import auto-complete emailaddress Using Outlook 4
T Outlook 365 won't take new working password Using Outlook 0
S Create Outlook Task from Template and append Body with Email Body Outlook VBA and Custom Forms 4
P Can't add custom field to custom Outlook form, it always adds to the Folder instead Outlook VBA and Custom Forms 2
B Sync Outlook Public Folders to Contacts Using Outlook 2

Similar threads

Back
Top