By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,775 Members | 2,658 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,775 IT Pros & Developers. It's quick & easy.

..SendObject...[help]

P: n/a
hi
I have found this code in this post
http://groups.google.it/groups?q=sen...il.com&rnum=16

++-------------------------------------------------------------------------++
Private Sub Comando4_Click()
Dim db As Database, rs As Recordset, sql As String, emailTo As String
Set db = CurrentDb()
emailTo = ""
sql = "select mail from inserimento_dati"
Set rs = db.OpenRecordset(sql)
Do Until rs.EOF
If Not IsNull(rs!mail) Then
'build up email addresses separated by a semicolon
emailTo = emailTo & rs!mail & "; "
End If
rs.MoveNext
Loop
DoCmd.SendObject acSendNoObject, , , emailTo, , , , , , True
End Sub
++----------------------------------------------------------------------++

it serves for sending a mail to more addresses...
but to me doesn't work!! argh!
it gives me this error...

Run Time Error '2295'
one or more unknown recipients.. message not envoy..

can someone help me?

do you address him some mails now he/she picks them up from a chart..
but if it had to pick them up from a query?? how can I do??
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.