Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 599
Default Link Excel Fields to Outlook Contacts

Steven

You can pull Outlook information into Excel through automation. Start here
http://www.dicks-clicks.com/excel/olContacts.htm

If you want to put every company in a data validation drop down, I would
suggest putting the list on a separate sheet and using that list as the
source for you data validation. If yoiu need more help, provide some
specifics about where you data goes and what you want to do with it.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Steven" wrote in message
...

From: "Steven"
Subject: Outlook Address book linked to Excel
Date: Tuesday, May 11, 2004 4:11 PM

I am looking for a way to display contact record information from within
Excel. How can I pull information into a worksheet based on current record
view within outlook. i.e., Company, Contact, Email, Phone, etc...???

Is there a way to do a data validation list to display all records from a
company field and have other named cells update based on the record
selected?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Contacts from Excel to Outlook Ergg Excel Discussion (Misc queries) 1 January 20th 10 10:12 PM
How do I export contacts from Excel back to Outlook Contacts? corvettego Excel Discussion (Misc queries) 2 August 17th 09 06:29 PM
Outlook - export contacts (custom additional fields) Greig Excel Discussion (Misc queries) 0 October 24th 08 05:27 AM
Selected Outlook contacts to excel landshark Excel Discussion (Misc queries) 1 April 17th 07 09:30 PM
How do I share excel contacts with outlook? amcpherso Excel Discussion (Misc queries) 1 April 28th 06 10:16 PM


All times are GMT +1. The time now is 12:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"