Search results

Problem is solved. The field with mailaddresses was a hyperlink field so the qry came back with mailaddress#mailto:mailadress#. Changed the field to text and now all works as it should. Thank you all for your support. @Mark_ my code works with .send. No problems with Outlook. @bastanu LDate is...

The qry was filtered by a field on the form. I removed the field from the qry and put it in the sql and used some quotes because it's a textfield. But now the next problem pops up: error -2147467259 (80004005) Can't recognize one or more names. The highlighted line is .send (at the end of the...

Set rstEMail = MyDB.OpenRecordset(strSQL, dbOpenForwardOnly)

Yes, but it's no problem to rename it if necessary.

I want to send mail from Access to multiple recipients. The recipients are in a table. The code gives me errorcode 3061. What am I doing wrong? Dim oApp As Object Dim oMail As Object Dim oByValue Dim Ldatum As String Dim AfzenderVN As String 'voornaam Dim AfzenderAN As...