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:
(Dates of emails in spreadsheet)
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.