Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 128
Default Excel VB and Lotus Notes Address Book

Hi

is this he end of the road?

any ideas? one for Dick Kusleika ?

thanks

Tim

"Tim Childs" wrote in message
om...
Hi

thanks for the post

this appears to be the code (below)

I could not get it to compile:
I received the message: "user defined type not defined in relation to
the first Dim statement.

I am on Lotus 5.0.6a, which should be OK but what is the Domino
Designer client mentoned in the spec. - presume I do not have it as I
am a ordinary, humble user of e-mail, so am stuck??.

Thanks

Tim


Sub foo()
Dim domSession As New Domino.NotesSession
Dim domDatabase As New Domino.NotesDatabase
Dim domDocument As NotesDocument
Dim domViewEntry As NotesViewEntry
Dim domView As NotesView
Dim domViewNav As NotesViewNavigator
Dim strName As String

domSession.Initialize
Set domDatabase = domSession.GetDatabase("", _
"names.nsf")
Set domView = domDatabase.GetView("Contacts")
' This view contains the list of names
Set domViewNav = domView.CreateViewNav
Set domViewEntry = domViewNav.GetFirstDocument()
Set domDocument = domViewEntry.Document

strName = domDocument.GetItemValue("FullName")(0)
MsgBox strName

Set domViewEntry = Nothing
Set domViewNav = Nothing
Set domView = Nothing
Set domDocument = Nothing
Set domDatabase = Nothing
Set domSession = Nothing

End Sub




"Dan Merchant" wrote in message

...
Tim,

This may not be the perfect answer but it should get you pointed in a

good
direction;



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Has anyone sent emails from Excel via Lotus Notes? Nick Bennett Excel Discussion (Misc queries) 2 May 8th 08 12:44 AM
??email excel sheet w Lotus notes Jaylin Excel Discussion (Misc queries) 3 October 12th 07 03:40 PM
Importing Lotus notes address book into EXCEL ron b Excel Discussion (Misc queries) 2 July 15th 07 08:56 PM
Lotus Notes Doc LINK in Excel??? Yogi Smith Excel Discussion (Misc queries) 0 July 10th 06 04:24 AM
Export Excel data to Lotus Notes 6.5 Address Book linz fiske Excel Discussion (Misc queries) 0 September 21st 05 10:20 PM


All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"