Sending a report via outlook

[neosam]

Hi,

Could someone tell me if the code i have written has the correct syntax.

DoCmd.SendObject acSendReport as acSpreadSheetType , "reportname", , "email@id.com", , , "report", "Pls find Report",,

[puppydogbuddy]

Hi,

Could someone tell me if the code i have written has the correct syntax.

DoCmd.SendObject acSendReport as acSpreadSheetType , "reportname", , "email@id.com", , , "report", "Pls find Report",,

DoCmd.SendObjec t acSendReport, "reportname ", acFormatXLS, "email@id.c om", , "report", Pls find Report", False


Syntax Per Access Help:

Syntax

DoCmd.SendObjec t [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

[neosam]

DoCmd.SendObjec t acSendReport, "reportname ", acFormatXLS, "email@id.c om", , "report", Pls find Report", False


Syntax Per Access Help:

Syntax

DoCmd.SendObjec t [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

Hi Puppydogbuddy

Thats awesome.. thanks...