Report on Outlook Mail items
Hi,
At my company out Nightly reports get sent out on 1 specific Machine.
There is normally 60+ Emails Sent.
I am wanting a macro that could send to excel Some Data.
Id need it to be able to be filtered by Date and possibly some other Fields.
I am fairly confident in Excel, so if someone could set up the basic macro and output settings, i'm sure i could add other filters/Output fields ect.
At my company out Nightly reports get sent out on 1 specific Machine.
There is normally 60+ Emails Sent.
I am wanting a macro that could send to excel Some Data.
Id need it to be able to be filtered by Date and possibly some other Fields.
I am fairly confident in Excel, so if someone could set up the basic macro and output settings, i'm sure i could add other filters/Output fields ect.
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is perfect.
Thank you.
From here i can make a few finer changes.
Thank you.
From here i can make a few finer changes.
You're welcome. Glad I could help.
Happy holidays.
Happy holidays.
ASKER
Is it possible to Add another column with the GUID?
So i can hyperlink into Outlook.
So i can hyperlink into Outlook.
Outlook items don't have a GUID. The closest you can get to a GUID is the EntryID property which is only unique within a particular information store. If you want that property then this will reference it
Item.EntryID
Item.EntryID
"send to excel Some Data"
You're going to have to be more specific about what data and where it's at before we can determine if we can help.