SendObject funtion

[CHAOSinACT]

I'm using access 2007 got the send object email ok... but what if i want to attach mutiple objects in one go or filter the report handed over?

if i've got

DoCmd.SendObject acSendReport, "rptCivilJobsSimpleList", "SnapshotFormat(*.snp)", "donna@d-group.com.au", "chis@d-group.com.au", , "Initiate Civil Job", "This e-mail has been sent by the D-Group Civil Database, Job Sheet for New Job attachted. Please do not respond to this e-mail.", True

i need to filter "rptCivilJobsSimpleList" and add a few more documents so it all goes in 1 email...

thanks in advance

 

[Poppa Smurf]

You may have to combine the reports as sub-reports into one report then email the report.

 

[CHAOSinACT]

lol that blows.