(Msg. 1) Posted: Fri Aug 21, 2009 1:34 am
Post subject: Advanced outlook trick: help needed! Archived from groups: microsoft>public>outlook>program_vba (more info?)
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
(Msg. 2) Posted: Fri Aug 21, 2009 5:05 am
Post subject: Re: Advanced outlook trick: help needed! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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. .
> Submitted using http://www.outlookforums.com
(Msg. 3) Posted: Fri Aug 21, 2009 8:05 am
Post subject: Re: Advanced outlook trick: help needed! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Michael Bauer [MVP - Outlook]" <mb DeleteThis @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. .
> > Submitted using http://www.outlookforums.com
(Msg. 4) Posted: Mon Aug 24, 2009 2:05 pm
Post subject: Re: Advanced outlook trick: help needed! [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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:
> "Michael Bauer [MVP - Outlook]" <mb.RemoveThis@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. .
>>> Submitted using http://www.outlookforums.com
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
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office