Find the sender who sent the mail from Generic Mailbox.

Status
Not open for further replies.

thirugusto

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
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
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
They are sending from the generic mailbox? If you use Send on behalf of permissions instead of send as, you can do it - otherwise Outlook just sees the generic mailbox. They'd need to do something you could look for - signature with their name or a custom field, code in the subject etc.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
In thinking about this more - I think i would use VBA to automatically assign a category to messages they reply to (and to the sent message). I don't have code handy to do this and I'm on vacation this week, but I'll try and put something together when I have time.

There is a macro at Sending Categories on Email Messages - Slipstick Systems that brings up the category dialog when composing messages. It's a start but is not automatic.
 

thirugusto

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Thanks Diane Poremsky !..

they need to send from generic mail box, not on behalf of.. and i guess categories option wont work for my situation bcz client may reject it.. i wanna go with searching a signature text in sent mail.

usually i will get the all this information by copy paste items to excel after i archive mails to my .pst folder. (Actually i got this idea from your website post only.. Thanks for that too.. )..

so now i want to read the signature of mails in my .pst folder.. can you help me to do it?..

i am in intermediate state with excel VBA but am just a beginner in outlook VBA. can you guide me with useful books n links..

Thanks again..

regards

thiru
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I usually recommend outlookcode.com to learn - plus books by Sue Mosher or Randy Byrne.

Quick version - use instant search, not VBA. In the search field, type the following, where keyword is the word in the signature you want to find

contents:keyword. If you want to get everything at once, use VBA to find the keyword and add a value to a field.

A quickie code sample is at Assign a keyword to a message - Slipstick Systems - it looks for a keyword and if found, adds the user name to the Billing Information field.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
B Looking to filter (or just find/search) for only messages that the sender has sent more than 1 messa Using Outlook 2
K Use VBA to find Sender and Recipient from Microsfot 365 Journaled Email Items Outlook VBA and Custom Forms 3
B Find related messages to sender Outlook VBA and Custom Forms 7
B Find Related Emails to sender Using Outlook 1
D Outlook 2007 Find All Related and Messages From Sender not working Using Outlook 3
W I have to find the sender's email address Outlook VBA and Custom Forms 2
R find sender info Outlook VBA and Custom Forms 5
witzker How to find all emails from and to a contact in OL 2019 Using Outlook 6
S How to find emails that I sent that have not received a reply? Using Outlook 7
M How can we find the list of users who are members of a deleted distribution list? Exchange Server Administration 2
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
H Outlook 2003 find by "has attachment" Using Outlook 1
geoffnoakes Find Contacts with UDFs "in this item" Using Outlook 1
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
B Outlook 2010 Can not find a certain file in M/S Outlook 2010. Using Outlook 1
T "cannot find the calendar folder for this item" - calendar items stuck in outbox Using Outlook 0
S Find a cell value in excel using outlook vba Using Outlook 1
B Search: Cannot find which Folder Contains a Message Using Outlook 3
K How to find specific header and copy the mail body Using Outlook 0
Hudas VBA find and open an email without looping thru each email in the inbox Outlook VBA and Custom Forms 1
E How to find or recover Lost e-mails within a folder under Inbox? Using Outlook 2
H "Advanced find: column for full folder path? Using Outlook 1
M What is the best way to find all records of an e-mail for our company? Outlook VBA and Custom Forms 2
C Find all deleted recurrence appointments Outlook VBA and Custom Forms 4
mrje1 Is there a Find and Replace feature in Outlook 2016? Using Outlook 4
G Can't find contacts entered Using Outlook 0
Connie Boyer Exporting Outlook calendar/find next repeating meeting Using Outlook 3
RBLampert Outlook "can't find" my e-mail server to receive messages Using Outlook 22
M Can't find messages Using Outlook 4
Diane Poremsky Find the Distribution Lists a Contact Belongs to Using Outlook 0
T Macro to find contacts by category and copy them to another folder Outlook VBA and Custom Forms 15
thomas zaleski Cannot find the Sending FOlder Using Outlook 2
J Find and Highlight text in outlook Outlook VBA and Custom Forms 4
J Outlook Mailbox cleanup; any way to change limit to find items older 999 days? Exchange Server Administration 2
F Disable "Find related messages" Using Outlook 1
Jennifer Murphy Can't delete or even find task attachment Using Outlook 1
K Re: Use Instant search to find messages from a contact Outlook VBA and Custom Forms 6
Andrew Hawkins "Advanced Find" Using Outlook 1
M BCM 2007 Can't find SS2012Express Using Outlook 2
O Outlook 2013 contacts - Where to find "Display as"-field Using Outlook 2
A Advanced find query facilty Help please Using Outlook 2
C Cant find emails after moving pst Using Outlook 1
G Find Organizer of appointment Using Outlook 2
R writing "Instant Search" queries to find User-Defined fields Using Outlook 0
P Outlook Advanced Find Using Outlook 0
S Advanced Find text field limits Using Outlook 2
C O2010: Using Advanced Find to locate exact queries Using Outlook 3
V Advanced Find - [Today]-3 ? Using Outlook 4
S Cannot Find Shared Database on Remote Computer BCM (Business Contact Manager) 13
V rule to Find some words in the subject, change subject then forward Using Outlook 1

Similar threads

Top