Wanting to move lots of outlook email, using excel as my "processor" to control where the email should be moved to
 

Is there a way, based on exported email, to id the message it was exported
from?

I would like to create a macro in excel, that would move emails from xfolder
to yfolder after sorting based on several different situations? I have many
years of emails I would like to batch process, and instead of reading each
email, I would like to sort based on where I worked (if through a work
account), what the product it was regarding (based on subject "contains" )
How many emails from or to a given address (should it require its own
folder - typically, if I get email that are not filtered out by the above,
if I receive 20 or more emails, I create its own folder)

So I have the need and desire to process the email in excel, but I do not
want to export and then process and IMPORT back into outlook. I just want to
use excel as a "processor" for moving the email. I want to keep the email
intact with all original formatting, attachments timestamps etc.


Here is my ideal situation

I export messages to excel, with the original folder in a column, then based
on certain conditions I either manually or automatically fill in NewFolder,
then I run a macro that would look in OrigFolder, find messageX, and then
MOVE that message to NewFolder

There are several things that appear to me to start with (besides my
ignorance with Outlook VBA), there are no guaranteed unique fields.
Is there a unique id for each email? I don't even see date and time stamp
when exporting. I could use SENDER and a date and time stamp to ID a
specific message, but those fields are not present.
If there is a way to id a specific message, how would I code the rest of
this?

Ikinda know excel VBA, but I don't know how to do any of the email stuff...

I am using office 2003

Thanks,
Mc

Wanting to move lots of outlook email, using excel as my "processor" to control where the email should be moved to
 

Write the code to export yourself and export the messages' EntryID and their
folders' StoreID properties as well.

After you have moved a message its EntryID might change. But as far as I
unuderstand you that would be ok.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - Categorize Outlook data:
http://www.vboffice.net/product.html...&lang=en&pub=6

Am Fri, 13 Apr 2007 15:14:16 -0700 schrieb Mctabish:

Is there a way, based on exported email, to id the message it was exported
from?

I would like to create a macro in excel, that would move emails from
xfolder
to yfolder after sorting based on several different situations? I have
many
years of emails I would like to batch process, and instead of reading each
email, I would like to sort based on where I worked (if through a work
account), what the product it was regarding (based on subject "contains" )
How many emails from or to a given address (should it require its own
folder - typically, if I get email that are not filtered out by the above,
if I receive 20 or more emails, I create its own folder)

So I have the need and desire to process the email in excel, but I do not
want to export and then process and IMPORT back into outlook. I just want
to
use excel as a "processor" for moving the email. I want to keep the email
intact with all original formatting, attachments timestamps etc.


Here is my ideal situation

I export messages to excel, with the original folder in a column, then
based
on certain conditions I either manually or automatically fill in
NewFolder,
then I run a macro that would look in OrigFolder, find messageX, and then
MOVE that message to NewFolder

There are several things that appear to me to start with (besides my
ignorance with Outlook VBA), there are no guaranteed unique fields.
Is there a unique id for each email? I don't even see date and time stamp
when exporting. I could use SENDER and a date and time stamp to ID a
specific message, but those fields are not present.
If there is a way to id a specific message, how would I code the rest of
this?

Ikinda know excel VBA, but I don't know how to do any of the email
stuff...

I am using office 2003

Thanks,
Mc

Wanting to move lots of outlook email, using excel as my "processor" to control where the email should be moved to
 

indeed, the EntryID is not unique. When you copy or move an email, the
ID changes!
Sendername and date/time should be unique, because one sender can only
sent one email at one moment..
I think MailToFile (www.mailtofile.com) will help you archiving all
email into an excel, access or csv file. In that case you have
information about all email.
But, how to find the email again in your Outlook. I think that's the
biggest problem. After moving an email to another folder in Outlook,
it can only be found again by searching all folders and check on your
own defined ID. This is not very neat.
Using mailtofile will archive your email to a directory, using the
same folders as you named in Outlook.
I don't see a solution for your rules, like moving mails in case you
receive 20 or more emails from one recepient.
I would like to suggest: choose the folders (or directories) yourself
and just collect all information about the email. In fact, you could
even archive all email in one folder, having a good database
containing all e-mail information..
I hope this will help you.


Michael Bauer [MVP - Outlook] schreef:
Write the code to export yourself and export the messages' EntryID and their
folders' StoreID properties as well.

After you have moved a message its EntryID might change. But as far as I
unuderstand you that would be ok.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - Categorize Outlook data:
http://www.vboffice.net/product.html...&lang=en&pub=6

Am Fri, 13 Apr 2007 15:14:16 -0700 schrieb Mctabish:

Is there a way, based on exported email, to id the message it was exported
from?

I would like to create a macro in excel, that would move emails from
xfolder
to yfolder after sorting based on several different situations? I have
many
years of emails I would like to batch process, and instead of reading each
email, I would like to sort based on where I worked (if through a work
account), what the product it was regarding (based on subject "contains" )
How many emails from or to a given address (should it require its own
folder - typically, if I get email that are not filtered out by the above,
if I receive 20 or more emails, I create its own folder)

So I have the need and desire to process the email in excel, but I do not
want to export and then process and IMPORT back into outlook. I just want
to
use excel as a "processor" for moving the email. I want to keep the email
intact with all original formatting, attachments timestamps etc.


Here is my ideal situation

I export messages to excel, with the original folder in a column, then
based
on certain conditions I either manually or automatically fill in
NewFolder,
then I run a macro that would look in OrigFolder, find messageX, and then
MOVE that message to NewFolder

There are several things that appear to me to start with (besides my
ignorance with Outlook VBA), there are no guaranteed unique fields.
Is there a unique id for each email? I don't even see date and time stamp
when exporting. I could use SENDER and a date and time stamp to ID a
specific message, but those fields are not present.
If there is a way to id a specific message, how would I code the rest of
this?

Ikinda know excel VBA, but I don't know how to do any of the email
stuff...

I am using office 2003

Thanks,
Mc

Wanting to move lots of outlook email, using excel as my "processor" to control where the email should be moved to
 

Frank, whether the mentioned tool would help 'Mc' or not is hard to say. It
seems that they first request for one's e-mail address before they (you?)
disclose any information about the tool. From my point of view that's no
good practice - and for me a no-go.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - Categorize Outlook data:
http://www.vboffice.net/product.html...&lang=en&pub=6


Am 18 Apr 2007 13:28:41 -0700 schrieb Frank:

indeed, the EntryID is not unique. When you copy or move an email, the
ID changes!
Sendername and date/time should be unique, because one sender can only
sent one email at one moment..
I think MailToFile (www.mailtofile.com) will help you archiving all
email into an excel, access or csv file. In that case you have
information about all email.
But, how to find the email again in your Outlook. I think that's the
biggest problem. After moving an email to another folder in Outlook,
it can only be found again by searching all folders and check on your
own defined ID. This is not very neat.
Using mailtofile will archive your email to a directory, using the
same folders as you named in Outlook.
I don't see a solution for your rules, like moving mails in case you
receive 20 or more emails from one recepient.
I would like to suggest: choose the folders (or directories) yourself
and just collect all information about the email. In fact, you could
even archive all email in one folder, having a good database
containing all e-mail information..
I hope this will help you.


Michael Bauer [MVP - Outlook] schreef:
Write the code to export yourself and export the messages' EntryID and
their
folders' StoreID properties as well.

After you have moved a message its EntryID might change. But as far as I
unuderstand you that would be ok.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - Categorize Outlook data:

http://www.vboffice.net/product.html...&lang=en&pub=6

Am Fri, 13 Apr 2007 15:14:16 -0700 schrieb Mctabish:

Is there a way, based on exported email, to id the message it was
exported
from?

I would like to create a macro in excel, that would move emails from
xfolder
to yfolder after sorting based on several different situations? I have
many
years of emails I would like to batch process, and instead of reading
each
email, I would like to sort based on where I worked (if through a work
account), what the product it was regarding (based on subject "contains"
)
How many emails from or to a given address (should it require its own
folder - typically, if I get email that are not filtered out by the
above,
if I receive 20 or more emails, I create its own folder)

So I have the need and desire to process the email in excel, but I do
not
want to export and then process and IMPORT back into outlook. I just
want
to
use excel as a "processor" for moving the email. I want to keep the
email
intact with all original formatting, attachments timestamps etc.


Here is my ideal situation

I export messages to excel, with the original folder in a column, then
based
on certain conditions I either manually or automatically fill in
NewFolder,
then I run a macro that would look in OrigFolder, find messageX, and
then
MOVE that message to NewFolder

There are several things that appear to me to start with (besides my
ignorance with Outlook VBA), there are no guaranteed unique fields.
Is there a unique id for each email? I don't even see date and time
stamp
when exporting. I could use SENDER and a date and time stamp to ID a
specific message, but those fields are not present.
If there is a way to id a specific message, how would I code the rest of
this?

Ikinda know excel VBA, but I don't know how to do any of the email
stuff...

I am using office 2003

Thanks,
Mc