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