Andrew McAuley 27.Jan.12 03:28 PM a Web browser
Domino Designer 7.0 Windows XP
I am pulling from a calendar and when I pull the Requiredattendees aka people and set it to thw workcell it is coming up double so for example.
steve and bobby are in the first do and in the second Craig and in the third craig and steve
so it print in excel like this
row 1 = steve,bobby
row 2 = steve,bobby,craig
row 3 = steve, bobby,craig,craig,steve
when they should read
row 1 = steve,bobby
row 2 = craig
row 3 = craig,steve
Anyone know how to get it to the way it should read
code below
Set doc = view.GetFirstDocument
While Not doc Is Nothing
If Instr(Ucase$(doc.Subject(0)), "ROADNET" )>0 Then
Forall n In doc.RequiredAttendees
Set workname = New notesname(n)
workcell = workcell & workname.Common & ";"
End Forall
REM While Not docProd Is Nothing
With xlSheet
row = row + 1
.Cells( row, 1 ).Value = doc.StartDate(0)
.Cells( row, 2 ).Value = workcell
.Cells( row, 3 ).Value = doc.subject(0)
REM doc.Subject(0)
End With
REM Wend
End If
Set doc = view.GetNextDocument(doc)
Wend
 Duplicate fields name. (Andrew McAuley 27.Jan.12)
 . . RE: Duplicate fields name. (Andrew McAuley 27.Jan.12)
| 
Return to top
Print this page
