<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Picking up Outlook address data etc.</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=178240200-29042003><FONT face=Arial color=#0000ff size=2>Yes,
CDO is free. It's behind MAPI, which is a pain. I personally find
CDO pretty easy to use.</FONT></SPAN></DIV>
<DIV><SPAN class=178240200-29042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=178240200-29042003><FONT face=Arial color=#0000ff size=2>Unless
everyone wants me to clutter the list with sample code, if you email me offline
Roz, I can probably send what you are going to need piece
meal.</FONT></SPAN></DIV>
<DIV><SPAN class=178240200-29042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=178240200-29042003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Roz Clarke
[mailto:roz.clarke@donnslaw.co.uk]<BR><B>Sent:</B> Monday, April 28, 2003 9:22
AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD]
Picking up Outlook address data etc.<BR><BR></FONT></DIV>
<P><FONT face=Arial size=2>Dear List</FONT> </P>
<P><FONT face=Arial size=2>Does anyone have the low-down on how to get data
out of Exchange? We're running Exchange 2000 with Office XP.</FONT> </P>
<P><FONT face=Arial size=2>What I need to be able to do is </FONT><BR><FONT
face=Arial size=2>a) automatically mail certain pre-defined staff members at
certain times (singly and in groups), and</FONT> <BR><FONT face=Arial
size=2>b) allow people to send ad-hoc mails from the database, selecting from
a list of staff members or typing in mail addresses.</FONT></P>
<P><FONT face=Arial size=2>Currently we are entering all email addresses
manually for the ad-hoc mails and relying on a local table of mail addresses
for the automated mails - a ridiculous duplication of effort when all this
stuff is on the system already.</FONT></P>
<P><FONT face=Arial size=2>So.... All I've managed to find on MSDN are some
references to something called CDO which can be used to extend Exchange
(though it's not wonderfully clear in what ways), but I can't see how to get
it and unless it's free I can't have it anyway.</FONT></P>
<P><FONT face=Arial size=2>Can anyone help?</FONT> </P>
<P><FONT face=Arial size=2>TIA</FONT> </P>
<P><FONT face=Arial size=2>Roz</FONT> </P></BLOCKQUOTE></BODY></HTML>