Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Excel VBA to send email using Lotus Notes

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Excel VBA to send email using Lotus Notes

On Wed, 27 Apr 2005 10:25:37 +0100, "Andy Wiggins" <newsgroups at bygsoftware d o t c o m wrote:

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?

Thanks for the input.

Each user can only use this code on their own machine, they can only access Notes from their own PC.

Our Notes team do not particularly encourage us to use macros so they will not assist us with any
coding problems.

Nirmal

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 107
Default Excel VBA to send email using Lotus Notes

Your Notes team should be able to tell you what the difference is between
setups on these machines.

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


"Nirmal Singh" wrote in
message ...
On Wed, 27 Apr 2005 10:25:37 +0100, "Andy Wiggins" <newsgroups at

bygsoftware d o t c o m wrote:

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?

Thanks for the input.

Each user can only use this code on their own machine, they can only

access Notes from their own PC.

Our Notes team do not particularly encourage us to use macros so they will

not assist us with any
coding problems.

Nirmal



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
assign a macro to send email in lotus notes from Excel spreadsheet pdaws Excel Worksheet Functions 0 May 6th 10 05:13 PM
How do I send an Excel workbook through Lotus Notes Email? Valerie Excel Discussion (Misc queries) 1 May 3rd 08 04:51 PM
?? Email Excel sheet thru Lotus Notes Jaylin Excel Discussion (Misc queries) 1 October 16th 07 05:12 PM
Send email with Lotus Notes Simon Excel Programming 1 May 6th 04 04:56 AM
Can you use code to Send excel spreadsheets via Lotus Notes?? Belzeddar[_3_] Excel Programming 2 January 19th 04 11:05 PM


All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"