G
Guest
I've been trying to create a button which sends a standard email message to
email addresses specified in a drop down menu in an access form.
I've been given a lot of help on this forum (thanks), but am re-posting
because couldn't resolve the issue, as I'm now faced with the error:
Runtime error '2293' Microsoft Office can't send this email message
when I try to send my message.
I've created a combobox linking to a table with names and email addresses.
I have created a simple button and at the data tab of the button's
properties I opened up a code builder box, and have entered the following
code:
Private Sub Command2_Click()
Dim strToWhom As String
Dim strMsgBody As String
Dim strSubject As String
strSubject = "Your Subject"
strToWhom = Me.Combo98.Column(2)
strMsgBody = "Your Body text goes here!"
DoCmd.SendObject , , , strToWhom, , , strSubject, strMsgBody, True
End Sub
Combo98 is the name of my combo box and column 2 is the column of that combo
box which contains the email addresses.
Anyway, been struggling with this for a couple of days now, so if anyone has
any further suggestions they'd be much appreciated.
Oh - and http://support.microsoft.com/kb/263084/en-us doesn't really help me
as I don't have access to out email server settings.
Many thanks in advance,
Adam
email addresses specified in a drop down menu in an access form.
I've been given a lot of help on this forum (thanks), but am re-posting
because couldn't resolve the issue, as I'm now faced with the error:
Runtime error '2293' Microsoft Office can't send this email message
when I try to send my message.
I've created a combobox linking to a table with names and email addresses.
I have created a simple button and at the data tab of the button's
properties I opened up a code builder box, and have entered the following
code:
Private Sub Command2_Click()
Dim strToWhom As String
Dim strMsgBody As String
Dim strSubject As String
strSubject = "Your Subject"
strToWhom = Me.Combo98.Column(2)
strMsgBody = "Your Body text goes here!"
DoCmd.SendObject , , , strToWhom, , , strSubject, strMsgBody, True
End Sub
Combo98 is the name of my combo box and column 2 is the column of that combo
box which contains the email addresses.
Anyway, been struggling with this for a couple of days now, so if anyone has
any further suggestions they'd be much appreciated.
Oh - and http://support.microsoft.com/kb/263084/en-us doesn't really help me
as I don't have access to out email server settings.
Many thanks in advance,
Adam