View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Wiggins Andy Wiggins is offline
external usenet poster
 
Posts: 107
Default Excel VBA to send email using Lotus Notes

If the code is working on all machines except one, then I would suggest that
it is the machine and Notes you need to look at and not this code.

Does the user, on this machine, have a Notes account?

What happens if a user, who can use this code, tries it on your rogue PC?

What do your Lotus Notes support people suggest?

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"Nirmal Singh" wrote in
message ...
I am using the following code

Set Session = CreateObject("Lotus.NotesSession")
Session.Initialize (PWD)
et Directory = Session.GetDbDirectory(Session.ServerName)
Set MailDatabase = Directory.OpenMailDatabase()
Set Document1 = MailDatabase.CreateDocument()
....


It works on all my users machines, apart from 1. He is getting the

following error message on the
second line above

Could not open the ID file.

We are using Lotus Notes with the userid files on a server.

Any ideas, anyone?

Nirmal