sending report to client's email address

[prmitchell]

I wish to a report to a selected client's email address where the client (Client ID) is selected by the user from a combo box.
I have tried

DoCmd.SendObject acReport, "Report for selected client", "PDFFormat(*.pdf)", "[ClientID]=”&ClientID, "", "", "", "subject", True, ""

which leads to an email message opening where the To is
[ClientID] = pm

The SQL I have in mind is

SELECT ClientID, email
FROM Clients
Where Clients.ClientID = Form![formname].[ClientID]

hope this helps, or just the first paragraph

 

[pr2-eugin]

Please refrain from Double Posting !!