Outlook 2003 - update contact with last activity date

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I journal my contacts, so can see all email exchanges from the
Activity tab. However, I just want to retrieve the date of the last
activity and either append it to the Notes section, or use it to
populate a custom field. Can this be done in Outlook directly? (I can
export the contacts/emails to Access and run queries there, but wanted
to know if there is a local solution)

Thanks!
 
you can always look for the date (after using Activates tab) and type it in
the field or it should be doable using VBA if you want to automate it.

--
Diane Poremsky [MVP - Outlook]





EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
 
Yes, so how do I refer to last activity date in the object model?

you can always look for the date (after using Activates tab) and type it in
the field or it should be doable using VBA if you want to automate it.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips:http://www.outlook-tips.net/
Outlook & Exchange Solutions Center:http://www.slipstick.com

Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visitinghttp://www.microsoft.com/office/community/en-us/default.mspxor point your
newsreader to msnews.microsoft.com.


I journal my contacts, so can see all email exchanges from the
Activity tab.  However, I just want to retrieve the date of the last
activity and either append it to the Notes section, or use it to
populate a custom field. Can this be done in Outlook directly?  (I can
export the contacts/emails to Access and run queries there, but wanted
to know if there is a local solution)
Click to expand...
Thanks!
Click to expand...
Click to expand...
 
You need to get the CDO mod date property (&H30080040) - you can use
Redemption and RDOSession instead of CDO. See outlookcode.com or the Outlook
VBA programming newsgroup (microsoft.public.outlook.program_VBA) on this
server.

--
Diane Poremsky [MVP - Outlook]





EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


Aurora said:
Yes, so how do I refer to last activity date in the object model?

you can always look for the date (after using Activates tab) and type it
in
the field or it should be doable using VBA if you want to automate it.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips:http://www.outlook-tips.net/
Outlook & Exchange Solutions Center:http://www.slipstick.com

Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by
visitinghttp://www.microsoft.com/office/community/en-us/default.mspxor
point your
newsreader to msnews.microsoft.com.


I journal my contacts, so can see all email exchanges from the
Activity tab. However, I just want to retrieve the date of the last
activity and either append it to the Notes section, or use it to
populate a custom field. Can this be done in Outlook directly? (I can
export the contacts/emails to Access and run queries there, but wanted
to know if there is a local solution)
Click to expand...
Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top