Add SQL to SendObject? 1

[PJFry]

Before I beat my head against the wall trying to do this, is there a way to use sql in the SendObject command?

For example...

DoCmd.SendObject acSendQuery, "qWVR", acFormatXLS, "hooty.mcboob@taxi.com", , , "First Pay Defaults","Please find attached the report for [u]SELECT MAX(tWVR.dtmBusinessDt) FROM tWVR GROUP BY tWVR.dtmBusinessDt [/u]"

Thanks in advance!
PJ

 

[PHV]

Like this ?
DoCmd.SendObject acSendQuery, "qWVR", acFormatXLS, "hooty.mcboob@taxi.com", , , "First Pay Defaults", "Please find attached the report for " & DMax("dtmBusinessDt", "tWVR")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PJFry]

Perfect! I have always seen the 'D' commands, but have never really looked into them. Thanks for the help!