Email and Lotus Notes

J

JAdams

Im using Access 2003 and Lotus Notes to send email.
My Access is using a "split database".
I have created the following code to send an email when the email button on
the form is clicked:

Private Sub Email_Click()
On Error GoTo Err_Email_Click
If Me.ManagerName = "Davison, Luella Y" Then
Dim stDocName As String
Dim strEmpName As String
Dim intFormID As Integer
stDocName = "Email Request For Time Off"
strEmpName = Me![Employee Name]
intFormID = Me![FormID]
DoCmd.SendObject acReport, stDocName, acFormatSNP, "(e-mail address removed)",
, , "Request For Time Off sent by: " & strEmpName, "Luella, please logon to
the KP Time Off Request Database and update form number: " & "[" &
intFormID & "]"
End IF
End Sub

The above code works great.

I have two PC's at my desk (1 Desktop & 1 laptop), both have Access 2003 and
Lotus Notes installed on them. When I use Access on my (Desktop) and click
the email button on the form to send the email, Lotus Notes places every
thing in its proper place. Meaning the To, Subject, Message Text and the
attachement are where they are suppose to be.

Here's my issue.
When I use my (laptop) and click on the email button on the form to send the
email, Lotus Notes places the following info in the (To:) section of the
email excluding the beginning and ending quotes:

"(e-mail address removed), please logon to the KP Time Off Request
Database and update form number: [2]
(e-mail address removed)"

The message text: (Luella, please logon to the KP Time Off Request Database
and update form number: [2]) is being added into the (To:) section and the
email recipient name is being repeated at the end just after the message text.


FYI: The subject line ("Request For Time Off sent by: " & strEmpName) and
the attachment are in their correct places.

Any idea why this my be happening when I use my laptop?

Both computers are using the desktop icon as the 'frontend' to the backend
database that's on the server.

Thanks so much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top