×

Loading...

Topic

  • May I ask if there any way to document emails? I try to create a log to monitor how many email request are comming and how many complete per day. However it is manually keyed in Excel now. Does outlook have any tools to achieve this? Many thanks.
    • 问你们IT,让他们设置一个report,每天update一下YTD的数据。
    • 有两种方法,一种是借用搜索文件夹的功能,比较简单。另一种是用VBA CODE. 我个人认为搜索文件夹功能比较容易一些:
      创建一个新的搜索文件夹Search Folder,可以取名为Total emails per day. In the Search Folder Criteria dialog, under Messages tab, separately select received and Today from the Time drop-down list. Then click OK. In the Select Folder(s) dialog, select the folder you want to count the total emails per day, and uncheck the Search subfolders box. Then click OK button. 剩下的就容易了。每天这个文件家里的内容会自动更新为当天收到的邮件,旧的会自动擦掉。每天瞄一眼这个文件夹旁括号里的数字就知道邮件总数了。
    • 你是问一天多少个要解决的邮件进来,又有多少个被解决掉? 进来的从server 或者hosting company那里容易得到数据。更像IT的活。
    • Thanks everyone, I have found the easy way to just copy all email to Excel sheet. But there are many duplicate emails back and forward and have to manual remove.
      • 先弄成conversation style的,然后再试试。不知道你为什么弄这个,如果是service group的话,KPI的一种,公司的软件应该有这个功能。如果不是的话,为什么要弄这个呢?
      • 我在统计每天多少个REQUEST,手下的人完成多少,计算出PRODUCTIVITY,是用来做KPI的,但现在总共多少REQUEST无法统计出来。