Solved

Outlook 2000 data to Lotus Notes

Posted on 2002-04-07
14
253 Views
Last Modified: 2013-12-18
I need to export data from a Custom Outlook form to Lotus Notes. The data is to be a new Notes document. Currently exporting data to Access which is then exporting to an Ascii file which is manually imported into Notes. I want to automate process from the Outlook/VBA/VBScript side. Using Access currently as data is added to Outlook data from an Oracle based Helpdesk system.

I don't have Notes and have never used notes, so any help would be very much appreciated.
0
Comment
Question by:vbmds
  • 8
  • 5
14 Comments
 
LVL 10

Expert Comment

by:zvonko
ID: 6924707
Hello vbmds,

from this your question and from your answered Outlook question is not completely clear what basis you now have and which direction you want to go, sorry.

Can you please explain in more details what your starting situation is.
Also important is which way you like to go, because there are always several roads to Rome :-)

From your two questions and from your EE member name I read that you do not plan to dive deep into Notes :-)
I suppose you prefer to do it from anywhere in Visual Basic and use Lotus Notes COM. This is possible.
But to make things less complicated for you and for experts involving in this question give please this answers:
1.) Where is the process initiated for this Outlook form (on Outlook or anywhere else)?
2.) Does this Outlook form lookup anywhere data while user is filling up its fields?
3.) Why do you have to switch from Access repository for Outlook form data to Notes?
4.) Has Access to be used parallel when Notes is form data repository?
5.) Do you in any case have to lookup or deposit data to Oracle?
6.) Can you send parts of your code to experts by email? My address is zp@arcor.de :-)

Waiting for your answers.

So long,
zvonko
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6924714
One very important additional info.

You can not send data to Notes server without locally installed Notes client. Every workstation sending data to Notes server has to have an user.id

Of course you can do it simple and send it as mail Carbon Copy from Outlook to a Notes MailIn database. This would be the easiest and best path for all involved parties. At receiving time in Notes mail in database, you can start further processing in any direction or simply store received documents :-)

0
 

Author Comment

by:vbmds
ID: 6924730
Thanks zvonko for your posts. I'll try and answer your questions to me.

Firstly, the 2 questions I have asked are unrelated.
Secondly, I am a remote contract programmer for the company causing me ask these questions. No-one within the company has a clue which is why I'm asking the questions.

Choice of products: The company uses MS Exchange/Outlook for its Email system. Lotus Notes is used as a Document Store for the Help Desk. Oracle is the Helpdesk application platform.

Currently my custom OL2K form is sent to external customers who fill it in and send it back. Currently the company open the reply, cut and paste into Excel and then import into Notes. They want to automate the import process. Reports are then generated. The Notes guru of the company knows nothing about MS Office Automation, and I about Notes.

I have brought Access into the picture to provide a Proof of Concept. That is; that we can get data out of a custom Outlook form.

So, basically, I want to replace Access with Notes, and ideally would like to do this using ADO...but can it be done.

The solution will be run on Workstations with Notes and Outlook installed. However, the company can not provide me with Notes to play with.

Hope this helps.
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6924790
Ok, very well.

Now is the picture complete for me :-)

Please send me your adapter between this Outlook form and the Access database. I can rewrite it to do the same to Notes database.
We can refine it later where this database has to be; locally or on Notes server. This is not a big difference for Notes.
Can you send me your code you used for concept proves?
I will paste afterwards all relevant information for other experts.

Send your zip with the Outlook form I can apply to my Outlook and the scripts (not the executables :-) for interchange between Outlook and access.
Send it to: zp@arcor.de

So long,
Zvonko
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6924913
Thanks for the Outlook form.
The investigation of it will take some time.

So long,
zvonko

0
 
LVL 10

Expert Comment

by:zvonko
ID: 6925239
I have sent you the firts release of the StoreNotesDoc procedure.
Tell me how it works for you so I can publish it here on EE...

So long,
zvonko

0
 
LVL 9

Expert Comment

by:Arunkumar
ID: 6925248
At the end of this you will beg for 300 pts right ?

;-)
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:vbmds
ID: 6926502
Thankyou Zvonko. I am demoing the process next week and so will post the outcome here. It looks good, so we can but hope.

Point taken Arunkumar, I was also thinking in the same vain.
0
 

Author Comment

by:vbmds
ID: 6985721
Cheers Zvonko for the help. Your code seems to whats needed.
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6985733
Thanks for the feedback :-)
0
 
LVL 10

Accepted Solution

by:
zvonko earned 200 total points
ID: 6985739
Oh, still no code here...
Could you please post a customized version for the EE community, please :-)
0
 

Author Comment

by:vbmds
ID: 6985826
Here is the final version of the code. This code is contained in the VBScript of the custom Outlook form.

Sub StoreNotesDoc()
'VB Script code for Export form
'Exports Outlook data to a Notes document, using VB Script
'Written by Zvonko Paunoski 8/04/2002
'Last modified 23/04/2002 by Mark Sollitt
'The data used by this sub is contained in the variables starting with 'db'
'The Notes database path has been left incomplete due to commerically sensitive nature
'of the real path to the company this sub is being used by.

  Dim domNotesSession
  Dim domNotesDatabase
  Dim domNotesDocument
  Dim domNotesItem

    Set domNotesSession = CreateObject("Lotus.NotesSession")
    Call domNotesSession.Initialize("lotusnotes") '// let empty string to allow user to enter password
    If Not (domNotesSession Is Nothing) Then
        Set domNotesDatabase = domNotesSession.GetDatabase("", "<path to database>/Survey.nsf")
        If Not (domNotesDatabase Is Nothing) Then
            Set domNotesDocument = domNotesDatabase.CreateDocument
            If Not (domNotesDatabase Is Nothing) Then
                Set domNotesItem = domNotesDocument.AppendItemValue("Form", "Survey")
                Set domNotesItem = domNotesDocument.AppendItemValue("jobID", CStr(dbJobID))
                Set domNotesItem = domNotesDocument.AppendItemValue("answer1", CStr(dbQ1))
                Set domNotesItem = domNotesDocument.AppendItemValue("answer2", CStr(dbQ2))
                Set domNotesItem = domNotesDocument.AppendItemValue("answer3", CStr(dbQ3))
                Set domNotesItem = domNotesDocument.AppendItemValue("answer4", CStr(dbQ4))
                Set domNotesItem = domNotesDocument.AppendItemValue("remoteuser", CStr(dbNTUser))
                Set domNotesItem = domNotesDocument.AppendItemValue("username", CStr(dbSDUser))
                Set domNotesItem = domNotesDocument.AppendItemValue("comments", CStr(dbComments))
                Set domNotesItem = domNotesDocument.AppendItemValue("org", CStr(dbCompany))
                Call domNotesDocument.Save(True, False)
            End If
        End If
    End If
    Exit Sub
End Sub
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6985852
Thank you Mark, now everyone knows my full name :-)

It is no problem for me, but until now only my buddies here knew my name :-)

Thank you also for the points and grading :-)

Until next time.

See you,
zvonko

0
 

Author Comment

by:vbmds
ID: 6987588
Sorry Zvonko, did not think. I was suprised that you asked me to make the code paste as I thought you were going to take care of it, and so did it in rush. Now that you mention it, my full name is in there as well.

You are welcome and I think certainly earned the points and Grade with all the work I had you doing to get it just right.

Ceya,
vbmds (Mark)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Email Message Background Color 4 125
Connect SQL Server from Lotus Domino Application 7 340
lotus domino server console error 1 80
Lotus notes - Follow up notes mail missing 15 68
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now