Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   Most recent contact date stored in an Outlook contact? (http://www.outlookbanter.com/outlook-using-contacts/23510-most-recent-contact-date-stored.html)

Jeff August 10th 06 02:55 PM

Most recent contact date stored in an Outlook contact?
 
Is there a way to store the most recent contact in an Outlook contact? It
seems like all that information is available in the Journal.

That way, if I have customers I want to talk to or email once a month, I can
create a call list of every customer where the most recent contact date is
30 days.

I know this functionality exists in Act! - and it seems like this should be
do-able in Outlook as well.

Jeff


Judy Gleeson \(MVP Outlook\) August 11th 06 01:15 AM

Most recent contact date stored in an Outlook contact?
 
You can do it manually by making a field "latest contact" and formatting it
as a date field. Then sort by date and you can see who you haven't rung in
say 3 months.

Use the Phone List view, turn on advanced toolbars and the Field Chooser has
a button to make a New... field. Once you make it, drag it onto the table
beside your existing fields.



"Jeff" wrote in message
...
Is there a way to store the most recent contact in an Outlook contact? It
seems like all that information is available in the Journal.

That way, if I have customers I want to talk to or email once a month, I
can
create a call list of every customer where the most recent contact date is

30 days.

I know this functionality exists in Act! - and it seems like this should
be
do-able in Outlook as well.

Jeff




Jeff August 11th 06 04:39 AM

Most recent contact date stored in an Outlook contact?
 
Judy,
You did answer the question I asked. What I meant to ask is "Is there a way
to have Outlook _AUTOMATICALLY_ store the date of last contact?"

Whenever you type an email to a contact, have an appointment with them, or
use Outlook to dial their phone number through a modem, it creates an entry
in the Journal. Is there a way to pick the most recent activity date from
the Journal and put it into a created "latest contact date" field for a
contact.

Act! 2000 does this automatically, and I got used to being able to sort by it.


"Judy Gleeson (MVP Outlook)" wrote:

You can do it manually by making a field "latest contact" and formatting it
as a date field. Then sort by date and you can see who you haven't rung in
say 3 months.

Use the Phone List view, turn on advanced toolbars and the Field Chooser has
a button to make a New... field. Once you make it, drag it onto the table
beside your existing fields.



"Jeff" wrote in message
...
Is there a way to store the most recent contact in an Outlook contact? It
seems like all that information is available in the Journal.

That way, if I have customers I want to talk to or email once a month, I
can
create a call list of every customer where the most recent contact date is

30 days.

I know this functionality exists in Act! - and it seems like this should
be
do-able in Outlook as well.

Jeff





James August 13th 06 06:31 PM

Most recent contact date stored in an Outlook contact?
 
Hi Jeff,to have Outlook automatically store the latest contact date,I
think,you'll have to write VBA codes,something like follows:
1.When Outlook creates an entry in the Journal,an Event named ItemAdd(Item
as Object) occurs,and in this case,Item returns the created JournalItem.
2.Pick the create date and contact name from that JournalItem.
3.Search for that contact name in the Contacts,and you get the
ContactItem,and
4.Put the create date into the custom field "latest contact date" for that
ContactItem.
Good luck.

"Jeff"
Judy,
You did answer the question I asked. What I meant to ask is "Is there a

way
to have Outlook _AUTOMATICALLY_ store the date of last contact?"

Whenever you type an email to a contact, have an appointment with them, or
use Outlook to dial their phone number through a modem, it creates an

entry
in the Journal. Is there a way to pick the most recent activity date from
the Journal and put it into a created "latest contact date" field for a
contact.

Act! 2000 does this automatically, and I got used to being able to sort by

it.


"Judy Gleeson (MVP Outlook)" wrote:

You can do it manually by making a field "latest contact" and formatting

it
as a date field. Then sort by date and you can see who you haven't rung

in
say 3 months.

Use the Phone List view, turn on advanced toolbars and the Field Chooser

has
a button to make a New... field. Once you make it, drag it onto the

table
beside your existing fields.



"Jeff" wrote in message
...
Is there a way to store the most recent contact in an Outlook contact?

It
seems like all that information is available in the Journal.

That way, if I have customers I want to talk to or email once a month,

I
can
create a call list of every customer where the most recent contact

date is

30 days.

I know this functionality exists in Act! - and it seems like this

should
be
do-able in Outlook as well.

Jeff








All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com