M
Monomeeth
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.
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.