Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing data from Outlook into Excel
Hello
What I would like to do is import the First Name, Last Name and "Alias" from every email in my Outlook Inbox into an Excel Spreadsheet containing 3 distinct dolumns for the data. We are using Outlook 2003 and Excel 2003, and our organisation uses MS Exchange Servers. If it helps to provide some context, the reason I need to do this is that I am managing a mailbox for an internal journal we produce. Readers wanting to subscribe are asked to send an email to the mailbox and up until now I have been manually going in and looking at their Outlook Properties and copying and pasting their names and User IDs (i.e. Aliases) from their Outlook Properties. However, I recently had four days off and upon my return I had 176 new emails sitting in the Inbox - so this is too many to do manually - especially with many more likely to come in over the XMAS/New Year's period while I'm away. I figure that this could be automated with the use of a macro run from Excel. Any help would be greatly appreciated! Thanks, Joe. -- If you can measure it, you can improve it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Excel via Outlook | Excel Discussion (Misc queries) | |||
Activating Outlook files and importing data from within Excel | Excel Programming | |||
Importing data from Excel to Outlook | Excel Discussion (Misc queries) | |||
Translaton Error when importing Excel data into Outlook? | Excel Discussion (Misc queries) | |||
importing Excell data into Outlook | Excel Programming |