Hi,

I want to write a code in Excel VBA which will conclude by sending an email
containing information entered in an Excel spreadsheet. Before I get started
I have a question regarding the recipient of that email.

Is it possible to use Excel VBA to display the emailadresses contained in
the Outlook personal adress book in order to select the recipient(s)?
Preferably this should be done without first importing the pab data in an
excel worksheet, so a dialog similar to the original one in Outlook would be
ideal.

Am i asking the impossible or is there a solution out there?

Thanks in advance,

Ron

Ron,

If you use the .Display method rather than .Send, you will open an Outlook
session, which gives you OL mail functionality, so you can browse the
address book from there.

--

HTH

Bob Phillips

"dB" wrote in message
. ..
Hi,

I want to write a code in Excel VBA which will conclude by sending an
email
containing information entered in an Excel spreadsheet. Before I get
started
I have a question regarding the recipient of that email.

Is it possible to use Excel VBA to display the emailadresses contained in
the Outlook personal adress book in order to select the recipient(s)?
Preferably this should be done without first importing the pab data in an
excel worksheet, so a dialog similar to the original one in Outlook would
be
ideal.

Am i asking the impossible or is there a solution out there?

Thanks in advance,

Ron