Sorting contact info by date

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

Hi Everyone:

I'm hoping you can help. Is there any way that you can
print a report that shows the last contact date for a
Contact. We are trying make a list of customers not
contacted within the last 3 months. Is there a way to
export it to Excel for instance and create a report that
way?

Thanks!
 
Assuming you already have a field populated with the last contact date for
each contact: Create a table view that shows that field and any other
fields you want to appear in the Excel spreadsheet. Set a filter on that
view to show only those contacts with a last contact date greater than 3
months into the past. Then select all items in that view (CTRL+A), copy the
data (CTRL+C), and paste into a blank Excel spreadsheet.

The other way to do it would be to export your Contacts directly to an Excel
spreadsheet using Outlook's Import/Export Wizard (on the file menu), then
sort the data any way you wish in Excel.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In
 
Back
Top