+ Reply to Thread
Results 1 to 2 of 2

getting sender of the mail which send from Generic Mailbox

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2007
    Posts
    6

    getting sender of the mail which send from Generic Mailbox

    hi All,

    i am working in BPO org. my team guys will publish reports to clients using outlook 2007. i want to track output mail sent time and input mails received time and mail sender name.

    i was doing it by simply copy the mailbox items and paste in Excel for further analysis(Tracking, team metrics, etc) - it worked well when our team guys publish the report from their mail box.

    Now our client want all the mails from one generic mail box. we introduced a shared mail box and instructed our guys to use the same for report publish. now i can track sent and received time

    but i couldn't track who send the mail...

    plz help me to solve this pblm..


    regards
    thiru
    - Thiru

  2. #2
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2003/2007
    Posts
    182

    Re: getting sender of the mail which send from Generic Mailbox

    Hi thiru,

    Try below code in a command button in an excel sheet. Rename an existing sheet as "MailData". Put your command button another sheet. Write below code in that button. It is working fine. Good Luck.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1