Date: Tue, 26 Jul 2011 23:26:10 +0800
Reply-To: Murphy Choy <goladin@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Murphy Choy <goladin@GMAIL.COM>
Subject: Re: Outlook Contact/Address Book
In-Reply-To: <7A211600F7953A4B84F17813455504CB14FB95DA1E@EX7T2-SV02.TDBFG.COM>
Content-Type: text/plain; charset=ISO-8859-1
Hi Lionel,
How about this?
http://support.sas.com/kb/25/631.html
On Tue, Jul 26, 2011 at 9:22 PM, Teed, Lionel <Lionel.Teed@td.com> wrote:
> Just doing some preliminary work on a business solution at work and was
> wondering if anyone has had success in retrieving, within a PC SAS job, some
> or all the contents of the Outlook Address Book?
>
> My early thoughts are to retreive the Enterprise address book information
> to populate certain fields that we need for a select subset of the entries
> on the Address book. In SQL terms, it would be something like this..
>
> Select t1.* from Enterprise_Address_Book as t1 Join
> ListofPeoipleWeAreInterestedIn as t2 on t1.KeyField=t2.KeyField.
>
> While t2 will be a SAS dataset, the trick is that t1 is our enterprise
> Contact/Address list.
>
> Any pointers to some SAS Papers or some gentle guidance would be
> appreciated.
>
> Of course, if some SAS smarty was to offer provide a full solution I
> wouldn't mind that either!!
>
>
>
>
> NOTICE: Confidential message which may be privileged. Unauthorized
> use/disclosure prohibited. If received in error, please go to
> www.td.com/legal for instructions.
> AVIS : Message confidentiel dont le contenu peut être privilégié.
> Utilisation/divulgation interdites sans permission. Si reçu par erreur,
> prière d'aller au www.td.com/francais/avis_juridique pour des
> instructions.
>
--
Regards,
Murphy Choy
Certified Advanced Programmer for SAS V9
Certified Basic Programmer for SAS V9
DataShaping Certified SAS Professional
|