keep track of the original sender

Status
Not open for further replies.
R

RWR3YXJk

Hi everybody,

I have written some VBA code to create a work log in Excel and when a user

clicks on a button it exports the sender , date and subject of an email to an

Excel file and when he finishes the job he clicks on another button and sends

a new record to Excel. My code works based on the open or Highlighted email

object so when an operator works on an email request and receives several new

email after that in order to correctly match his worklog records he needs to

go back to original email and highlight it or open it and then click the

"Done" button. My question is : it is possibile to keep track of openning

email ( original request) somehow that when we want to send the "Done" it can

find the original email among hndreds of emails and send a new record to

Excel.

TO restate my question: Is there an efficent way to lets say have a userform

( keeping a list of email that an operator has opend to work on ) and then

the same user can go to that list and select it and send correct info to

Excel file.

My other question would be: if i have a sendr name and email recived date

how can I find the same email object among hundreds of emails ?

I use OL2003 and exchange server 2003

Best regards,

Edward
 
K

Ken Slovak - [MVP - Outlook]

If you have a reference to an item get the EntryID property, then to

retrieve that item again later use the NameSpace.GetItemFromID() method with

that persisted EntryID value. You can omit the optional StoreID property (it

refers to the mailbox or PST file), or you can get it and use it. To get

StoreID use something like this, where "item" is the selected item:

Dim strStoreID As String

strStoreID = item.Parent.StoreID

item.Parent refers to the folder the item lives in and that object exposes

the StoreID property.

"Edward" <Edward> wrote in message

news:3969A06E-C2E7-476D-B84E-80F059F6B034@microsoft.com...
> Hi everybody,
> I have written some VBA code to create a work log in Excel and when a user
> clicks on a button it exports the sender , date and subject of an email to
> an
> Excel file and when he finishes the job he clicks on another button and
> sends
> a new record to Excel. My code works based on the open or Highlighted
> email
> object so when an operator works on an email request and receives several
> new
> email after that in order to correctly match his worklog records he needs
> to
> go back to original email and highlight it or open it and then click the
> "Done" button. My question is : it is possibile to keep track of openning
> email ( original request) somehow that when we want to send the "Done" it
> can
> find the original email among hndreds of emails and send a new record to
> Excel.
> TO restate my question: Is there an efficent way to lets say have a
> userform
> ( keeping a list of email that an operator has opend to work on ) and then
> the same user can go to that list and select it and send correct info to
> Excel file.
> My other question would be: if i have a sendr name and email recived date
> how can I find the same email object among hundreds of emails ?
> I use OL2003 and exchange server 2003
> > Best regards,
> Edward
 
R

RWR3YXJk

Thanks Ken, I'll try that.

Best regards,

Edward
wrote:


> If you have a reference to an item get the EntryID property, then to
> retrieve that item again later use the NameSpace.GetItemFromID() method with
> that persisted EntryID value. You can omit the optional StoreID property (it
> refers to the mailbox or PST file), or you can get it and use it. To get
> StoreID use something like this, where "item" is the selected item:

> Dim strStoreID As String
> strStoreID = item.Parent.StoreID

> item.Parent refers to the folder the item lives in and that object exposes
> the StoreID property.

> >

>

> "Edward" <Edward> wrote in message
> news:3969A06E-C2E7-476D-B84E-80F059F6B034@microsoft.com...
> > Hi everybody,
> > I have written some VBA code to create a work log in Excel and when a user
> > clicks on a button it exports the sender , date and subject of an email to
> > an
> > Excel file and when he finishes the job he clicks on another button and
> > sends
> > a new record to Excel. My code works based on the open or Highlighted
> > email
> > object so when an operator works on an email request and receives several
> > new
> > email after that in order to correctly match his worklog records he needs
> > to
> > go back to original email and highlight it or open it and then click the
> > "Done" button. My question is : it is possibile to keep track of openning
> > email ( original request) somehow that when we want to send the "Done" it
> > can
> > find the original email among hndreds of emails and send a new record to
> > Excel.
> > TO restate my question: Is there an efficent way to lets say have a
> > userform
> > ( keeping a list of email that an operator has opend to work on ) and then
> > the same user can go to that list and select it and send correct info to
> > Excel file.
> > My other question would be: if i have a sendr name and email recived date
> > how can I find the same email object among hundreds of emails ?
> > I use OL2003 and exchange server 2003
> > > > Best regards,
> > Edward


>
 
R

RWR3YXJk

Ken,

I'm not an expert in outlook programming , so sorry if i'm asking a trivial

question, I got the EntryID and I keep its value in a modul level string

variable to use it in other procedures later. the problem i have I can only

retrieve it's value once

like

msgbox myNameSPace.GetItemFromID(myID).SenderName

after this code runs and displays the correct data somehow myID variable

which holds the vaure of the EntryId gets cleared and it's value becomes

empty "" so the next time when I run the same code I get an error.

I don't know why this variable dosn't keep the value? any thoughts?

Best regards,

Edward
wrote:


> If you have a reference to an item get the EntryID property, then to
> retrieve that item again later use the NameSpace.GetItemFromID() method with
> that persisted EntryID value. You can omit the optional StoreID property (it
> refers to the mailbox or PST file), or you can get it and use it. To get
> StoreID use something like this, where "item" is the selected item:

> Dim strStoreID As String
> strStoreID = item.Parent.StoreID

> item.Parent refers to the folder the item lives in and that object exposes
> the StoreID property.

> >

>

> "Edward" <Edward> wrote in message
> news:3969A06E-C2E7-476D-B84E-80F059F6B034@microsoft.com...
> > Hi everybody,
> > I have written some VBA code to create a work log in Excel and when a user
> > clicks on a button it exports the sender , date and subject of an email to
> > an
> > Excel file and when he finishes the job he clicks on another button and
> > sends
> > a new record to Excel. My code works based on the open or Highlighted
> > email
> > object so when an operator works on an email request and receives several
> > new
> > email after that in order to correctly match his worklog records he needs
> > to
> > go back to original email and highlight it or open it and then click the
> > "Done" button. My question is : it is possibile to keep track of openning
> > email ( original request) somehow that when we want to send the "Done" it
> > can
> > find the original email among hndreds of emails and send a new record to
> > Excel.
> > TO restate my question: Is there an efficent way to lets say have a
> > userform
> > ( keeping a list of email that an operator has opend to work on ) and then
> > the same user can go to that list and select it and send correct info to
> > Excel file.
> > My other question would be: if i have a sendr name and email recived date
> > how can I find the same email object among hundreds of emails ?
> > I use OL2003 and exchange server 2003
> > > > Best regards,
> > Edward


>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
T Why is every new email pinned (to keep it on top)? Windows 10 Using Outlook 6
T Missing text in e-mail message after "(Please keep confidential)" Using Outlook 3
CWM030 Outlook 2016 with imap emails keep Resurrecting themselves? Using Outlook 5
D Keep Original html body when forwarding an email Outlook VBA and Custom Forms 7
O Wishlist Native solution to detach attachments but keep a link to them Outlook Wishlist 1
Scorpion New Contacts keep coming up as company Using Outlook 1
M Multiple workstations and multiple accounts - keep in sync? Using Outlook.com accounts in Outlook 2
M How to keep reccurence during copy tasks to calendar? Using Outlook 1
Patrick van Berkel Best way to share (and keep up-to-date) Macro's in Outlook 2010 Outlook VBA and Custom Forms 6
Karsten V Reminders keep popping up way after past reject Using Outlook 0
H Keep Original email unread after autoreply Outlook VBA and Custom Forms 2
A Keep color categories when saving vCards Using Outlook 1
Mark Klaassen HOw to keep Outlook iCloud add-in enabled Using Outlook 4
R Can't keep emails synced on various devices Using Outlook.com accounts in Outlook 4
piusg 2013: Task Views keep disappearing Using Outlook 4
Dan Badur How can I keep indenting OFF on replies in Outlook 2013? Using Outlook 1
S how to keep "To" when move sent emails to other folder Using Outlook 1
K Deleted emails keep coming back Using Outlook 3
D Need Help with Script. Keep getting Runtime Error 438 BCM (Business Contact Manager) 4
A How to add personal notes to a meeting - and keep them if update sent? Using Outlook 1
A outlook trying to keep sending Using Outlook 1
B Closing Exchange service, how to keep all calendar and mail data? Exchange Server Administration 0
D How to keep Outlook 7 open to full screen Using Outlook 2
S How do I keep my old PST file as default Exchange Server Administration 1
Z Keep Unread Messages in same folder Using Outlook 2
L Oulook always "disconnected" how do I keep it open all of the time? Using Outlook 1
P emails with attachments keep sending... HELP!!! Using Outlook 4
F Not keep sort order after re-change column Using Outlook 1
M How do you keep sent emails in the PST folder in outlook 2013 Using Outlook 1
N Contact Groups - names keep changing from Contacts to AddressBook Using Outlook 5
M Reminders keep coming to users' calendar Exchange Server Administration 1
L Outlook 2010 - Keep getting "Corrupted File" Msgs Using Outlook 4
W Outlook 2010 Share calendar but keep color formatting Using Outlook 2
mrje1 Assigned Categories keep getting deleted in mail, bug? How to fix if possible? Using Outlook 5
S Reminders keep popping up, even after dismissing them Using Outlook 9
T Outlook keep loosing connection to the exchange server Using Outlook 1
P deleted items keep reappearing in my deleted folder Using Outlook 4
P Stationary and view layout keep changing after reboot? Using Outlook 1
Y MICROSOFT OUTLOOK 2007 - i KEEP GETTING THE "ENTER NETWORK PASSWORD" BOX POPPING UP - IT IS ALREADY Using Outlook 4
A How to keep all conversations expanded? Using Outlook 3
Q I cannot start Outlook 2007 I keep getting this error: __'Cannot start outlook window. Invalid XML,the view cannot be loaded.' Using Outlook 3
S Deleted messages keep coming back Using Outlook 7
A Keep format of message in the body Outlook VBA and Custom Forms 1
R How do I keep old calendar events from disappearing? BCM (Business Contact Manager) 2
C Reminders keep appearing without being requested BCM (Business Contact Manager) 4
B Track Record Activity Using Outlook 1
R When rules lose track of "specified folder" Using Outlook 6
R Track Sent Emails that have not been Responded Using Outlook 1
M How best to track OUTGOING referrals? BCM (Business Contact Manager) 2
J Looking for a solution (maybe an add-in) to easily track email conversations Using Outlook 3

Similar threads

Top