LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you tell Excel to send emails through Outlook? Donald S Excel Discussion (Misc queries) 1 June 30th 05 05:21 PM
creating spreadsheet with colunms for names adresses & zipcodes neilabu Excel Discussion (Misc queries) 4 March 4th 05 12:53 AM
Link Soucre changes when Spreadsheet opened from with within Outlook Cy Eze Links and Linking in Excel 0 January 6th 05 04:43 PM
Creating Spreadsheet Calculations Glenn Excel Discussion (Misc queries) 2 December 17th 04 04:01 PM
Creating a summary from existing spreadsheet data ... NP Excel Worksheet Functions 8 October 29th 04 02:39 PM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"