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