Hi,
I am trying to send an individualised report pdf to a number of people in my organisation using a macro. It is all working well and I have got a working loop that selects each individual one at a time and sends the email with the pdf attachment. The To field in the macro is set to retrieve the email address from a field in an open form [Forms]![frmAttendance]!.
I have used this in the past with no problem, but now Access says they could not identify the recipient and stops the macro. If I enter the To line manually then it sends the email correctly (but with 500+ emails to send this is not an option).
The email field in the underlying table is set to Short Text.
Any thoughts?
Many thanks,
Pino
I am trying to send an individualised report pdf to a number of people in my organisation using a macro. It is all working well and I have got a working loop that selects each individual one at a time and sends the email with the pdf attachment. The To field in the macro is set to retrieve the email address from a field in an open form [Forms]![frmAttendance]!.
I have used this in the past with no problem, but now Access says they could not identify the recipient and stops the macro. If I enter the To line manually then it sends the email correctly (but with 500+ emails to send this is not an option).
The email field in the underlying table is set to Short Text.
Any thoughts?
Many thanks,
Pino