$$Excel-Macros$$ Re: Lotus Notes via excel

2009-02-23 Thread Harmeet Singh
goto vb editor window->tools->reference then add all microsoft object library On Fri, Feb 20, 2009 at 5:42 PM, radek lustyk wrote: > Hello Harmeet > > This code has stopped on this 3 lines, maybe this is some library issue ? > >> >>"* Dim ClipBoard As DataObject 'Data object for getting text

$$Excel-Macros$$ Re: Lotus Notes via excel

2009-02-20 Thread radek lustyk
Hello Harmeet This code has stopped on this 3 lines, maybe this is some library issue ? > >"* Dim ClipBoard As DataObject 'Data object for getting text from > clipboard >Set ClipBoard = New DataObject > ClipBoard.GetFromClipboard"* > > thanks Radek --~--~-~--~~--

$$Excel-Macros$$ Re: Lotus Notes via excel

2009-02-18 Thread Harmeet Singh
Try the following code: Dim Maildb As Object'The mail database Dim UserName As String 'The current users notes name Dim MailDbName As String'The current users notes mail database name Dim MailDoc As Object 'The mail document itself Dim AttachME As Object

$$Excel-Macros$$ Re: Lotus Notes via excel

2009-02-16 Thread humtumharehain
Private Sub CommandButton1_Click() agentname = Sheet1.Cells(1, 1) Dim oWrkSpace As Object Dim oCrntDoc As Object Set oWrkSpace = CreateObject("Lotus.NotesSession") Set oCrntDoc = oWrkSpace.currentDocument Call oCrntDoc.FieldSetText("EmailSentTo", "murtaza") Call oCrntDoc.Fie

$$Excel-Macros$$ Re: Lotus Notes via excel

2009-02-16 Thread Murtaza Dalal
Sorry dev it gives me error at this line Set oCrntDoc = oWrkSpace.CurrentDocument On Mon, Feb 16, 2009 at 11:04 AM, Murtaza Dalal wrote: > Hey Dev i tried using this code but it gives me an error where is need to > enter the sent to email id. Can you check on that plz? > > > On Fri, Feb 13, 200

$$Excel-Macros$$ Re: Lotus Notes via excel

2009-02-16 Thread Murtaza Dalal
Hey Dev i tried using this code but it gives me an error where is need to enter the sent to email id. Can you check on that plz? On Fri, Feb 13, 2009 at 1:46 AM, Dev wrote: > > This is not tested...Just pulled from my memory. The below script > combines both vba and lotus script. More faster and

$$Excel-Macros$$ Re: Lotus Notes via excel

2009-02-16 Thread humtumharehain
Hi Dev i tried using this code but i get error on this line. Can you help me with it plz? Set oCrntDoc = oWrkSpace.CurrentDocument On Feb 13, 1:16 am, Dev wrote: > This is not tested...Just pulled from my memory. The below script > combines both vba and lotus script. More faster and elegant. >

$$Excel-Macros$$ Re: Lotus Notes via excel

2009-02-13 Thread Dev
This is not tested...Just pulled from my memory. The below script combines both vba and lotus script. More faster and elegant. Dim oWrkSpace As Object Dim oCrntDoc As Object Set oWrkSpace = CreateObject ("Notes.NotesUIWorkSpace") Set oCrntDoc = oWrkSpace.CurrentDocument Call oCrntDoc.FieldSetT