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...
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...