A
andy
SendObject is a useful function until it is used for the fifth or sixth
time. I have an access database in which contains an email address field on
the "main" table. I want that email address to be clickable and when it is
clicked it opens the default MAPI email client filling in the nexessary
spaces.
The code works fine until i have clicked on 5 or 6 email addresses at which
point any addresses i continue to click on do not do anything.
Here is my code :-
---------------------------code snip ----
Private Sub Email_Click()
On Error GoTo Err_Command35_Click
DoCmd.SendObject acSendNoObject, , acFormatTXT, , , , , "Dear " &
[FirstName] & " " & [Surname], True
Exit_Command35_Click:
Exit Sub
Err_Command35_Click:
MsgBox Err.Description
Resume Exit_Command35_Click
End Sub
-----------------------end snip --------
time. I have an access database in which contains an email address field on
the "main" table. I want that email address to be clickable and when it is
clicked it opens the default MAPI email client filling in the nexessary
spaces.
The code works fine until i have clicked on 5 or 6 email addresses at which
point any addresses i continue to click on do not do anything.
Here is my code :-
---------------------------code snip ----
Private Sub Email_Click()
On Error GoTo Err_Command35_Click
DoCmd.SendObject acSendNoObject, , acFormatTXT, , , , , "Dear " &
[FirstName] & " " & [Surname], True
Exit_Command35_Click:
Exit Sub
Err_Command35_Click:
MsgBox Err.Description
Resume Exit_Command35_Click
End Sub
-----------------------end snip --------