Recent content by Venkata Murugan Guna

Oh ok..not a problem I will do it on my own :-). thanks for helping hand..will keep you posted about the progress

Hi Diane, I was able to clean up the code and got that working..Thank you so much for your help. It was indeed 10 months effort. Now i want this macro to take into new height and i want your help again. As i said earlier, I am tracking / want to track shared email account where team sits in...

Happy Diwali...Diane.. Wow Wow Wow....i dont have words to express my happiness. Your responses to my help is outstanding. Let me try and come back to you.

Hi Diane, Thank you so much for replying. I did checked in vba editor and it was indeed correct result i got. Now i want this to be populated in new field as and when email is received. Is there any way we can call this macro as and when replied and result be stamped in new field?. I am also...

I am so happy that you are responding to my questions. I wil explore on this but I am actually looking a solution inside outlook as against any other applications interference

Yes Diane, you are right I want to know the # of working hours between the mail arriving and the reply. So you are saying if I add LDate = GetTargetDate(myMail.ReceivedTime, 36) in outlook new field will this populate the desired result?

Hi Diane, Could you have a look at this link, this is exactly i was looking for. If I get this particular thing work and populate the result (or call the macro when email responded and populate the result in the new field) that would be great. VBA - Outlook 2010 - Using ReceivedTime of email in...

Oh ok. But why is that last verb not capturing seconds? For all the emails it is showing as "00" in seconds

Hi Diane, Hope you are good. I am still working on this (at my leisure time) and found the difference between Last verb executed time and Modified time. While creating new field for Received time, Modified time and Last verb executed time to capture seconds (hh:mm:ss). i see there is a...

Yeah you are right. I will have to work on this this week end with out any distraction

This is going beyond my skills o_O. Let me try mean while if you could also lend me your hand that would be of great help

Hi Diane, Datediff gives the result including weekends but I am looking at working days

Hi Diane, I have applied alternative to Mod function and it worked great. but i am hitting the wall at beyond 24 hour format :-( Working Day field - correct answer both in excel and outlook : IIf([Last Verb Exec Type]<>"None",INT((WEEKDAY([Received]-2)+[Last Verb Exec...

Yeah..Yeah...i understand Mod is an equation...Thanks Diane..for taking your time and replying. I am working on it and will let you know once i figure it out :-)

If that is the case, Can I go ahead and directly put this formulae =(SUM(INT((WEEKDAY(A3-{2,3,4,5,6})+B3-A3)/7))-1)*("17:00"-"8:00")+MOD(B3,1)-MOD(A3,1).