20$ Export from outlook to Excel

[Excel Fox]

Can be done. I will take this up. Need clarification on something. In your sample file, there are subject lines that start with RE: and FW:

If we take out these characters, your pivot table will look lot more clear and sensible. Can you do that, and then check if we can work on that data? Also, after you do that, can you put in the expected output (for a few samples).

Also, the original macro needs to pick the SMTP address of the sender.

[jamilm]

Dear Administrator

i do not need the RE: and FW: please take those out.

please look into my post Sophisticated Chalange calculating business hours between two dates in Excel

the case numbers are basically each subjects for emails. that is basically what i need. that from outlook emails are exported (FW and RE can be disregarded) then for each email between time received and actions the working hours are calculated.

please see that post in mrexcel forum and let me know if more clarificatiion is needed.

your help is very much appreciated.

Can be done. I will take this up. Need clarification on something. In your sample file, there are subject lines that start with RE: and FW:

If we take out these characters, your pivot table will look lot more clear and sensible. Can you do that, and then check if we can work on that data? Also, after you do that, can you put in the expected output (for a few samples).

Also, the original macro needs to pick the SMTP address of the sender.

[jamilm]

hope you can figure out something this weekend for this outlook code which pending for too long