Creating spreadsheet of Outlook emails
 

New to this, so if you know of helpful relevant links and info, please
tell me. I havn't been able to find much info.

Code he http://mejobloggs.pastebin.com/497155
A lot of it is copied from some examples around the net, but they
didn't really explain things.

Description: I have mailbox size limits, so I want to be able to store
my emails in an excel spreadsheet for easy viewing. I want to be able
to run the macro to get all emails from the mailbox. I will then delete
all the emails in the inbox, because they are now in the spreadsheet.
Whenever my mailbox gets too full, I will just repeat the process, and
all the emails will be added to the spreadsheet. I want the spreadsheet
to be sorted by date automatically.

Also want to remove any duplicate emails.

Mainly I just want general advise on how to do all this. Should I be
loading the spreadsheet into an array to make the sorting work properly

Problems:
The sorting. It doesn't work properly. Example:

28.11.2005 09:44
27.10.2005 04:49
27.09.2005 07:00
26.12.2005 10:28
26.11.2005 07:27
26.08.2005 17:35
25.12.2005 02:48
25.11.2005 11:46
25.10.2005 12:06
24.11.2005 02:48
23.10.2005 01:13

Seems to be sorting it by day. No idea how to fix it.

I have the olMail.EntryID to check for duplicate emails, but I am not
sure how to go about it. Do I load all emails into the spreadsheet,
then set it to delete duplicates from the spreadsheet? Or do I stop the
duplicate from writing to the spreadsheet in the first place? It
already takes a while to run, so I wan't to do it in a way that works
quickly.

Thanks.

Creating spreadsheet of Outlook emails
 

Argh, have I just made my email address available for spammers? I see
lots of people are using alias emails and such. Wish I had figured that
out before joining with my real email :(

Creating spreadsheet of Outlook emails
 

Argh, have I just made my email address available for spammers? I see
lots of people are using alias emails and such. Wish I had figured that
out before joining with my real email :(

Creating spreadsheet of Outlook emails
 

There is perhaps a better way to do what you want than using Excel.

I assume that your size limitation in Outlook is like mine and it is
based on messages in your PUBLIC FOLDERS. You can solve this by moving
mail from the Public Folders to your Personal Folders.

In Outlook, under Personal Folder, create another folder for Inbox
(call it "A -My Inbox")(The "A" keeps the folder at the top of the list
of Personal Folders where it is easier to find). Then create a Rule
using the Rules Wizard (Tools Rules Wizard) to move all messages 1kb
<10000kb in size to this new inbox and delete them from the Public
Folder Inbox. Then simply do your work from the "A-My Inbox".

This rule will only run when you have Outlook open so when you first
open Outlook, you will see new mail in the original Inbox for a few
seconds but then they should automatically be copied and then deleted.
You should also do the same thing with your sent items folder (if you
automatically save outgoing mail in this folder). The only other
glitch in this process is that if you are on vacation for an extended
period and don't open Outlook during that time, the rule never gets
activated and mail continues to collect in the public folder Inbox -
and your Outlook will begin rejecting incoming mail based on your inbox
being full.

Otherwise, it works great - I haven't had a problem for over three
years.


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=499238