+ Reply to Thread
Results 1 to 4 of 4

Excel VBA to send email using Lotus Notes

  1. #1
    Nirmal Singh
    Guest

    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. #2
    Andy Wiggins
    Guest

    Re: 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" <nirmal.singh@towerhamlets.removethisbitgov.uk> wrote in
    message news:426f58fc.1542453@news.microsoft.com...
    > 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. #3
    Nirmal Singh
    Guest

    Re: 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. #4
    Andy Wiggins
    Guest

    Re: 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" <nirmal.singh@towerhamlets.removethisbitgov.uk> wrote in
    message news:42710ab0.27002750@news.microsoft.com...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1