If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
keep track of the original sender
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 |
Ads |
#2
|
|||
|
|||
keep track of the original sender
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. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Edward" wrote in message ... 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 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 |
#3
|
|||
|
|||
keep track of the original sender
Thanks Ken, I'll try that.
-- Best regards, Edward "Ken Slovak - [MVP - Outlook]" 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. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Edward" wrote in message ... 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 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 |
#4
|
|||
|
|||
keep track of the original sender
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 "Ken Slovak - [MVP - Outlook]" 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. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Edward" wrote in message ... 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 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Original Sender Read Forwarded Invitations/Messages..Possible? | TLS | Outlook - Calandaring | 1 | December 22nd 07 02:36 PM |
Reply and automatically save address of original sender | Ronnie | Outlook - Using Contacts | 1 | November 6th 07 09:04 PM |
Hide original sender when forwarding?? | Richard Preston | Outlook Express | 5 | July 7th 07 07:07 PM |
Sender used a recall attachment, can track each opening | grover | Outlook - General Queries | 6 | September 23rd 06 05:42 PM |
How can I find the original sender from auto-forwarded messages? | Honey | Outlook Express | 4 | August 24th 06 04:01 PM |