Try to export a report as an attachment

[gblack]

I have a report that gets passed a paramter value when opened.

I am current trying to send the report as an attchment, but because the report must have the parameter value and the DoCmd.SendObject doesn't seem to have a place for an arg... I have to first open the report, then try to send it... like so:

DoCmd.OpenReport "00100_Rpt_Document(Draft)", acViewPreview, , , , intAgreementID
        DoCmd.SendObject acSendReport, "00100_Rpt_Document(Draft)", acFormatPDF, "gary.black@xxx.gov", , , "Sending A Report", "This is the Access Report"
        DoCmd.Close acReport, "00100_Rpt_Document(Draft)"

When I do this I get an error message stating:

No profiles have been created. To create a new profile, use the Mail icon in the Control Panel.

And if I try to use just the SendObject command Access just hangs:

        DoCmd.SendObject acSendReport, "00100_Rpt_Document(Draft)", acFormatPDF, "gary.black@xxx.gov", , , "Sending A Report", "This is the Access Report"

I have seen two post on this site pertaining to the error message I posted, but no one ever responded to them, which doesn't bode well I guess


Thanks for any help,
Gary