Solved

Getting the data from Lotus Notes to Outlook

Posted on 2013-12-17
15
606 Views
Last Modified: 2013-12-19
IMAP ConfigurationHi,
 
 I have a customer who used to work for the company with Lotus Notes and now he works for the company with Outlook.

He wants all of  this email/contact on Lotus Notes imported into Outlook. Currently he can  access lotus notes server online (https://mail.DomainName.com) however I can't export the information.

 So I contacted an IT person of previous company and he said to my his server is IMAP enabled. I created an IMAP account in Outlook, but it fails to connect.

 What other options are there to accomplish the task?

 Thanks in advance.
0
Comment
Question by:sglee
  • 9
  • 6
15 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 500 total points
Comment Utility
If I were one of the Admins at the previous organisation and if I did my job well, I'd have blocked the user as well. From a legal point of view, it all seems to be working as it should. Now, from a technical point of view:
- is the correct IMAP port open?
- is the user's address correct?
- is user's password correct? did he use IMAP before? if not, did he have an Internet password (which can be different from the Notes password)
0
 

Author Comment

by:sglee
Comment Utility
@sjef_bosman
Have you connected Outlook to Lotus notes account over the internet previously without any add-ons?
0
 

Author Comment

by:sglee
Comment Utility
IMAP PortsPort Test Result from OutsideAccording to the IT person of prev. company, appropriate ports - 143 for TCP/IP and 993 for SSL - are open. Please see the screenshot above.
But when I test these two ports from outside using port test site, they say that these ports are closed.
0
 
LVL 46

Assisted Solution

by:Sjef Bosman
Sjef Bosman earned 500 total points
Comment Utility
Yes, I used IMAP over the Internet before, more specifically Mozilla Thunderbird. It works, no doubt about that.

I expect that the previous organisation didn't open the IMAP port (or ports?) on the firewall. When you do a port scan an all ports <1000 you'll probably find none open, or maybe only numbers 80 or 25.  You'll have to contact them to get one IMAP port open.
0
 

Author Comment

by:sglee
Comment Utility
@sjef_bosman
You were right. The IT guy did not open the port. But later he did opened the port and I also installed an Microsoft add-in for Outlook 2002 and for Outlook 2003 for connection with IBM Lotus Notes release 5.x or 6.x servers (http://www.microsoft.com/en-us/download/details.aspx?id=19573). After that, my Outlook 2003 successfully connected to my customers Lotus mailbox.

After a few more adjustment in Outlook settings, I was able to access all sub-folders in his Lotus mailbox. I am trying to export them into PST, but one email in one of the sub-folders keeps preventing emails from being backed up.  I tried to export that particular folder where there is a bad email (which I can open individually in Outlook and open a 3MB PDF attachment), but it failed.

What do you think I should do?
0
 
LVL 46

Expert Comment

by:Sjef Bosman
Comment Utility
Can't you read/copy the mail separately, delete it, and then back up the folder?

> I also installed an Microsoft add-in for Outlook...
Did you really have to do that? Plain IMAP didn't do what you want?

> ... where there is a bad email  ...
We could argue about this, of course, but the mail isn't bad. Please put the blame on Outlook.
0
 

Author Comment

by:sglee
Comment Utility
IMAP Error w/ Outlook Add-inDid I really have to install Microsoft add-in for Outlook?  --> Yes. without it, I was getting an error like above (Acutally I set up this IMAP account on another PC w/o the add-in to give you an answer).

I asked the IT guy to move the folder (in trouble) to another area temporarily so that I can back it up.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 46

Expert Comment

by:Sjef Bosman
Comment Utility
Maybe some explanation of Notes folders comes in handy. Most importantly: they don't exist. Well, not physically, for they are just a name tagged to a mail. A Notes folder is merely a collection of mails with the same tag. A mail can have multiple tags, and therefore appear in multiple folders. If you want ALL mail, irrespective of the folder, you might consider to fetch all mails in All Documents (if there is such a name in the list).
0
 

Author Comment

by:sglee
Comment Utility
Since it was successful to create an IMAP account in Outlook 2003 (in my test environment), I decided to create the same IMAP account on my customer Outlook 2007, but it fails to connect to Lotus Notes. I think it needs "Outlook 2007 with Outlook Add-in: Notes Connector" or something equivalent.

Yesterday my Outlook 2003 did not connect to Lotus notes until I installed  Outlook 2003 with Outlook Add-in: Notes Connector.

Can you help?
0
 

Author Comment

by:sglee
Comment Utility
Let me take it back.
In my another test PC where I have Outlook 2007, I created IMAP account and successfully connected to Lotus Notes.
However when I did the same on my customer's Outlook 2007, it fails to connect.
I went to Outlook Help/About and confirmed that they both have the same version.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
Comment Utility
If everything else is the same, maybe your customer's firewall (company or personal) doesn't permit outward-bound connections on IMAP?
0
 

Author Comment

by:sglee
Comment Utility
Let me check with my customer's IT company about it. That is a possibility.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
Comment Utility
Or their provider maybe. My provided doesn't allow SMTP (port 25) connections to addresses other than my provider's.
0
 

Author Comment

by:sglee
Comment Utility
I see. I emailed to an IT administrator of the office where my client has an office inside. Let's see what he has to say.
0
 

Author Closing Comment

by:sglee
Comment Utility
After the IT guy at the previous company made necessary adjustments in his firewall and Lotus notes, I was able to access all of the emails and created PST file from Outlook with IMAP account.

Thanks for your help.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Resolve DNS query failed errors for Exchange
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

762 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

14 Experts available now in Live!

Get 1:1 Help Now