Could someone help with the following?

I am using Access 2003 with outlook 2003 and all I need to do is open
outlook and for it to display the Select Names Dialog Box ( it would be nice
to open outlook if it was closed) no more than that. Hence I am now after
the code to go in the click event of the button.

Any examples of VBA code that will work within Access 2003 would be
appreciated

The Select Names dialog box is programmable starting from Outlook
2007. You can't display it in Outlook 2003.

http://msdn.microsoft.com/en-us/library/bb176400.aspx

--JP

On Feb 5, 3:52*pm, wrote:
Could someone help with the following?

I am using Access 2003 with outlook 2003 and all I need to do is open
outlook and for it to display the Select Names Dialog Box ( it would be nice
to open outlook if it was closed) no more than that. Hence I am now after
the code to go in the click event of the button.

Any examples of VBA code that will work *within Access 2003 would be
appreciated

Thank you Jp for the info.
In view of your reply, I have seen code being used (VB) for the display of
the address book.
Have you used or knowledge of any outlook VBA address book code examples?

I will post a message in this group on this subject.

Thank you again

I don't doubt that you've seen code that displays the address book,
but Outlook doesn't provide any means of doing so prior to Outlook
2007. I have seen (and used) VBA code that manipulates contacts, but
not in the way you want. If you can show otherwise, I'd be glad to see
it.

--JP

On Feb 9, 12:32*pm, wrote:
Thank you Jp for the info.
In view of your reply, I have seen code being used (VB) for the display of
the address book.
Have you used or knowledge of any outlook VBA address book code examples?

I will post a message in this group on this subject.

Thank you again

Of course in the old days we used to use CDO.Session.AddressBook() to
display that dialog before the OOM exposed it.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"JP" wrote in message
...
I don't doubt that you've seen code that displays the address book,
but Outlook doesn't provide any means of doing so prior to Outlook
2007. I have seen (and used) VBA code that manipulates contacts, but
not in the way you want. If you can show otherwise, I'd be glad to see
it.

--JP

On Feb 9, 12:32 pm, wrote:
Thank you Jp for the info.
In view of your reply, I have seen code being used (VB) for the display of
the address book.
Have you used or knowledge of any outlook VBA address book code examples?

I will post a message in this group on this subject.

Thank you again

Hi ,all

I came across the example of using the address book in this
http://www.codeguru.com/forum/showthread.php?t=370829 and hoped to get this
working some how.

That is what I was talking about with the CDO method.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


wrote in message
...
Hi ,all

I came across the example of using the address book in this
http://www.codeguru.com/forum/showthread.php?t=370829 and hoped to get
this
working some how.

Hi, Ken
Is it possible to get the example working in the environment I need?
If so your help would be appreciated
Regards
Dave

That thread you referenced has code for that.

CDO is an optional installation for Office 2003 and earlier so you may not
have it installed, you have to check that. CDO also is subject to very
strict security, even stricter than the Outlook object model, so you also
have to be aware of that. Most of us stopped using CDO years ago because of
that, that's one of the reasons that Redemption (www.dimastr.com/redemption)
was created.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


wrote in message
...
Hi, Ken
Is it possible to get the example working in the environment I need?
If so your help would be appreciated
Regards
Dave

Hi, Ken
I am using the following code that basicly works, other than if outlook is
closed.
hence what code is required to open outlook if it is closed?
It also looks like .AddressBook has a number of options. Could you list or
point me to more information on the use of this command.

On Error GoTo err_Session_AddressBook
'MAPI Session
Dim objSession As MAPI.Session
Dim colCDORecips As Object

Set objSession = New MAPI.Session
'objSession.Logon "ProfileName", "outlook", False, False
objSession.Logon , , False, False
'show address book
Set colCDORecips = objSession.AddressBook(, _
"Pick Names", , , 1, _
"Recipients")
' release objects
objSession.Logoff

Set colCDORecips = Nothing
Set objSession = Nothing


err_Session_AddressBook:
If (Err = 91) Then ' MAPI dlg-related function that sets an object
MsgBox "No recipients selected"
Else
'MsgBox "Unrecoverable Error:" & Err
End If

Thank you

Dave