Send emails to an access database?

  • Thread starter Thread starter tbrown7777
  • Start date Start date
T

tbrown7777

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
 
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".
 
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.
 
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.
 
Back
Top