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.
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.