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