Using Access 2003 to send E-mail through Lotus Notes

Posted on 2005-03-10
Medium Priority
Last Modified: 2013-12-18
I am trying use Access 2003 to send e-mail through Lotus Notes. I have login with my account. But when I execute the code "Set mailDb = Session.GetDatabase("", "mail\hching.nsf")", it prompts "user CN=Howard HW Ching/O=TheLinkMgt cannot open database CN=LMMAIL01/O=TheLinkMgt!!mail\shcfu.nsf". shcfu.nsf is the file used by the previous user of the PC (he no longer used this PC).

Why? Can anybody help me?

Dim mailDb As Object
Dim Username As String
Dim MailDBName As String
Dim mailDoc As Object
Dim Session As Object
Set Session = CreateObject("Notes.NotesSession")
Username = Session.Username
Set mailDb = Session.GetDatabase("", "mail\hching.nsf")
If mailDb.IsOpen = True Then
End If
Set mailDoc = mailDb.CreateDocument
mailDoc.Form = "Memo"
mailDoc.sendto = "Howard HW Ching"
mailDoc.Subject = "testing"
mailDoc.body = "Testing messgae"
mailDoc.SaveMessageOnSend = True
mailDoc.posteddate = Now()
mailDoc.Send 0, Recipient
Set mailDb = Nothing
Set mailDoc = Nothing
Set Session = Nothing

Question by:howardching
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 31

Expert Comment

ID: 13513469
Open Notes, then choose...

    (R5)    File -> Tools -> Switch ID
    (R6)    File -> Security -> Switch ID

... and change to your ID file.  That should make it work.  If it does not work at that opint, you probably have multiple copies of Notes, or multiple copies of NOTES.INI available.
LVL 31

Accepted Solution

qwaletee earned 2000 total points
ID: 13513476
One other thing... make sure your LOCATION DOCUMENT has the correct mail file listed.

    File -> Preferences -> Location preferences
    Click MAIL tab
    Make sure it has your mail file
    Also check server tab, make sure home server is your mail server
    Click SAVE & CLOSE

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

741 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