Emailing report to address held in field

[ham355]

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

[June7]

Is the report actually open and viewable on-screen when you run the SendObject code? The email address is in a field on the report? This is for a single address? How is the report filtered to single address? Can refer to a variable in place of the literal address text. The variable can be a reference to control on form or report.

[ham355]

Hi June, thanks for your reply, but I have managed to figure out a solution!

Regards

[webisti]

I do have the same issue as in the begining of the thread
How did u solved it?

regards

Webisti

[June7]

In case ham doesn't come back, a clue to possible solution is in my previous post. Refer to control on form as input for the address.

DoCmd.SendObject _
acSendReport, _
"Hosu Raw Query 2", _
acFormatPDF, _
Me.controlname, _