Automatically export e-mail from Outlook by timeframes

Feb 20, 2013 at 9:23 AM

I want to create a dynamic network from my corporate e-mail inbox and I need timestamps/timeframes for that (by minute, hour, day, week, month, etc.). But in NodeXL file for e-mail I couldn't find a date/time column, like in twitter data.

Of course I can make it manually (at least for weeks and months), but I wonder if there is any VBA script to make it automatically?

Best regards,
Feb 21, 2013 at 10:22 PM
Edited Feb 22, 2013 at 5:16 PM

If you are asking about the feasibility of an "email date" column on the Edges worksheet, then that isn't possible.

Each row that NodeXL's "Import from Email Network" feature adds to the Edges worksheet can represent multiple emails. A row for John and Mary, for example, indicates that NodeXL found one or more emails that showed a relationship between John and Mary. The number of such emails is indicated in the Edge Weight column. Because the different emails had different dates, there is no way to specify one date for the relationship.

If I misunderstood your question, let me know.

-- Tony