Try this (it seems to work in Access 2000): File -> Get External Data -> Import Under "Files of Type:", choose Outlook() It will walk you through importing your address book into a table. From there you should be able to query the address book. This is assuming you've got all the addresses stored locally on your computer. If you're connecting to a server through LDAP (to an NT server presumably), you'd have to use <CFLDAP> which is no fun. Reply if this helps... Good luck! Norman Elton Information Technology - Network Engineering College of William & Mary -----Original Message----- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 8:00 PM To: [EMAIL PROTECTED] Subject: Crazy MS Outlook/Access Question Hi, I want to know if anyone has ever attempted the impossible and how it was done. I have about 300 names in an Access database that I would like to send a mass email to, but the Access database did not contain their email addresses. What I was thinking is since they all work for the same company maybe I could do a query from MS Outlook and populate my database with their emails from Outlook, doing a simple WHERE statement that would match their First and Last names. Is this possible or should I get started on manually entering their addresses?? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ---------------------------------------------------------------------------- -- Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
