R
rwinans
I am using a concatenate function to loop through a table and build a single
email distribution text box in a form. I want to be able to click on the text
box and have Outlook open a new message with the emails in the BCC field. My
email code seems to work when the distribution list is small, but when it is
large (50+ emails) I get an Error 87 message. Can anyone help? Here is my
email code:
Private Sub Email_DblClick(Cancel As Integer)
Dim strEmail As String
strEmail = Me.Email
strEmail = "mailto:?bcc= " & strEmail
Application.FollowHyperlink strEmail
End Sub
email distribution text box in a form. I want to be able to click on the text
box and have Outlook open a new message with the emails in the BCC field. My
email code seems to work when the distribution list is small, but when it is
large (50+ emails) I get an Error 87 message. Can anyone help? Here is my
email code:
Private Sub Email_DblClick(Cancel As Integer)
Dim strEmail As String
strEmail = Me.Email
strEmail = "mailto:?bcc= " & strEmail
Application.FollowHyperlink strEmail
End Sub