Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you tell Excel to send emails through Outlook? | Excel Discussion (Misc queries) | |||
creating spreadsheet with colunms for names adresses & zipcodes | Excel Discussion (Misc queries) | |||
Link Soucre changes when Spreadsheet opened from with within Outlook | Links and Linking in Excel | |||
Creating Spreadsheet Calculations | Excel Discussion (Misc queries) | |||
Creating a summary from existing spreadsheet data ... | Excel Worksheet Functions |