Send emails to an access database?
 

My company recently banned pst files and will only allow emails to be stored
for 90 days (damn those lawyers) in my inbox. I was wondering if anyone had
any ideas how I could go about running a macro and have it save the file into
an access database? the pain i'm having is that when I have several email
messages come in for a project I'm working on, they all have the same title
and won't save to my hardrive without renaming them. Hence the need for a
macro. If I categorized them based on my old pst directories, i think i can
make it really cool. I hate having to sort through hundreds of emails and
file them every weekend!! If anyone has any ideas, I'd appreciate it.

thanks,
Tim

Send emails to an access database?
 

What do you want to save to Access, data from the emails or the actual
emails? Those would have to be stored as some sort of binary blob and then
you'd need code to retrieve them and read them as Outlook items. It might be
easier to just save the items to the file system in specific folders and
append numbers to the files if they have subjects that are already in the
folders as files.

So if you find a "Foobar" in that folder you make the new item "Foobar1", if
you have "Foobar1" there you make the new item "Foobar2".

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"tbrown7777" wrote in message
...
My company recently banned pst files and will only allow emails to be
stored
for 90 days (damn those lawyers) in my inbox. I was wondering if anyone
had
any ideas how I could go about running a macro and have it save the file
into
an access database? the pain i'm having is that when I have several email
messages come in for a project I'm working on, they all have the same
title
and won't save to my hardrive without renaming them. Hence the need for a
macro. If I categorized them based on my old pst directories, i think i
can
make it really cool. I hate having to sort through hundreds of emails and
file them every weekend!! If anyone has any ideas, I'd appreciate it.

thanks,
Tim

Send emails to an access database?
 

I would like to save the entire email with attachments. The problem with the
files, is that it's much more difficult to find what your looking for sifting
through titles. I took the preview forgranted! In fact, trying to sit down
every Friday and clean out my inbox is a chore too. I would like to write
some code to ask me where I want to file it. My only choice right now is in
a file buried on my hardrive.



"Ken Slovak - [MVP - Outlook]" wrote:

What do you want to save to Access, data from the emails or the actual
emails? Those would have to be stored as some sort of binary blob and then
you'd need code to retrieve them and read them as Outlook items. It might be
easier to just save the items to the file system in specific folders and
append numbers to the files if they have subjects that are already in the
folders as files.

So if you find a "Foobar" in that folder you make the new item "Foobar1", if
you have "Foobar1" there you make the new item "Foobar2".

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"tbrown7777" wrote in message
...
My company recently banned pst files and will only allow emails to be
stored
for 90 days (damn those lawyers) in my inbox. I was wondering if anyone
had
any ideas how I could go about running a macro and have it save the file
into
an access database? the pain i'm having is that when I have several email
messages come in for a project I'm working on, they all have the same
title
and won't save to my hardrive without renaming them. Hence the need for a
macro. If I categorized them based on my old pst directories, i think i
can
make it really cool. I hate having to sort through hundreds of emails and
file them every weekend!! If anyone has any ideas, I'd appreciate it.

thanks,
Tim

Send emails to an access database?
 

So save the items to the file system to a temporary location as MSG files.
Then take those saved MSG files and add them to your database as binary
blobs.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"tbrown7777" wrote in message
...
I would like to save the entire email with attachments. The problem with
the
files, is that it's much more difficult to find what your looking for
sifting
through titles. I took the preview forgranted! In fact, trying to sit
down
every Friday and clean out my inbox is a chore too. I would like to write
some code to ask me where I want to file it. My only choice right now is
in
a file buried on my hardrive.