Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
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 againthe 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

![]() |
![]() |
![]() |

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |