Hi all, I am using the code below in a swithboard, to generate and email a report (the email@email.com is replaced with my email address)
However, I hold email addresses in the query to which the report pulls from, so it would be useful to send the report to the address held in that field. How is that achievable please?
My field is simply called 'EmailTo' - Thanks! Ian
Private Sub Option1_Click()
DoCmd.SendObject _
acSendReport, _
"Hosu Raw Query 2", _
acFormatPDF, _
"email@email.com", _
, _
, _
"HOSU Report", _
"Please find attached your latest HOSU Report, Thanks, Ian", _
False
End Sub