Link to home
Start Free TrialLog in
Avatar of sglee
sglee

asked on

Getting the data from Lotus Notes to Outlook

User generated imageHi,
 
 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.
ASKER CERTIFIED SOLUTION
Avatar of Sjef Bosman
Sjef Bosman
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sglee
sglee

ASKER

@sjef_bosman
Have you connected Outlook to Lotus notes account over the internet previously without any add-ons?
Avatar of sglee

ASKER

User generated imageUser generated imageAccording 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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sglee

ASKER

@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?
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.
Avatar of sglee

ASKER

User generated imageDid 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.
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).
Avatar of sglee

ASKER

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?
Avatar of sglee

ASKER

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.
If everything else is the same, maybe your customer's firewall (company or personal) doesn't permit outward-bound connections on IMAP?
Avatar of sglee

ASKER

Let me check with my customer's IT company about it. That is a possibility.
Or their provider maybe. My provided doesn't allow SMTP (port 25) connections to addresses other than my provider's.
Avatar of sglee

ASKER

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.
Avatar of sglee

ASKER

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.