i have this statement

DoCmd.SendObject acQuery, "etc etc etc

then i have another one

DoCmd.SendObject acQuery, "etc etc etc

but only one will work, at any one time

the code sends an query ex access as an excel document via email

basically it will only execute the DoCmd.SendObject acQuery,
once and not again

the values in the statements are only different by the file name

i have tryied seperating them into different modules and it will only execute once.

if i close the application and reopen it, again i can only use the statement once.

full code is below

DoCmd.SendObject acQuery, "actpe", "MicrosoftExcel(*.xls)", emailaddress, "", "", "Automated Call Centre Stats " + subjectdate, "Average Call Time per Extension and Total Calls Made, There is a copy already saved in j:\this other file", False, ""

DoCmd.SendObject acQuery, "tctpe", "MicrosoftExcel(*.xls)", emailaddress, "", "", "Automated Call Centre Stats " + subjectdate, "Total Call Time per Extension and Total Calls Made , There is a copy already saved in j:\this file", False, ""

why can i only run this once

rgds,

Mark