Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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: (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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating spreadsheet of Outlook emails
Excel really is NOT the tool for doing something like this. Why not just
create an archive directory on your local drive and archive your old e-mails into there. Outlook has a bunch of options to make this easy and fast. -- HTH... Jim Thomlinson " wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating spreadsheet of Outlook emails
Because that means I have to open up every email in the folder to look
it it. I want a way I can quickly browse a number of old emails |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Emails in 2 folders. Outlook 2007 | Excel Discussion (Misc queries) | |||
Inport Outlook emails into Excel | Excel Discussion (Misc queries) | |||
Creating spreadsheet of Outlook emails | Excel Discussion (Misc queries) | |||
Import emails from outlook folder as TXT | Excel Programming | |||
Can you tell Excel to send emails through Outlook? | Excel Discussion (Misc queries) |