Frazzled1,
Although the following is based on a snippet of one of my Access scheduled jobs, this might help you visualize a solution/process. Always different and sometimes better ways, but this is my meager solution approach.
sample.cmd This is the job that actually is called by AT or Task Scheduler.
==================
@echo off
rem ''''''''''''''''''''''''''''''''''''''''''''''
rem ProgramName: sample.cmd
rem Written by: Douglas Cranston
rem Purpose: Test for the existence of
rem a new sample.xls file for sending
rem to the selected personnel
rem Run sampleit.vbs script
rem Cron: Set up in AT to run on the
rem 1st working day of new month
rem ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
rem
rem Test if the file exists and if so jump to
rem run the necessary commands, else quit
rem
rem
c:
cd\cmdfiles\wrk
rem
if exist sample.xls del sample.xls
rem
cd\cmdfiles
rem
rem since old xls is gone run prgm
rem to create new version.
rem
"c:\program files\microsoft office\office\msaccess.exe" e:\database\sample.mdb sampleextrct
rem sampleextrct is your Access or Excel macro, in my case creates a report in Excel format
rem
rem test to see if .xls exists and if so
rem jump to prcess goto and run from there
rem else fail
rem
cd\cmdfiles\wrk
if exist sample.xls goto prcess
rem
rem Fall out and stop if file does not exist
rem
rem Notify Admin that the file was missing
rem
c:
cd\cmdfiles
call sampleno.vbs
echo date /t >> c:\cmdfiles\sample.log
echo time /t >> c:\cmdfiles\sample.log
echo sampleno >> c:\cmdfiles\sample.log
exit
rem
rem Label for the goto that when file exists
rem it jumps to this part of the program and
rem executes the remaining commands.
rem

rcess
rem
rem Notify Admin that the program successfully ran
rem
c:
cd\cmdfiles
call sampleyes.vbs
echo date /t >> c:\cmdfiles\sample.log
echo time /t >> c:\cmdfiles\sample.log
echo sampleyes >> c:\cmdfiles\sample.log
sampleno.vbs
================
Dim MyBody
Dim MyCDONTSMail
set MyCDONTSMail = CreateObject("CDONTS.NewMail"

MyCDONTSMail.From = "yourmail@server.net"
MyCDONTSMail.To = "administrator@server.net"
MyCDONTSMail.Subject = "Sample FAILED"
MyBody="Update was not successful." & VbCrLf
MyCDONTSMail.Body=MyBody
MyCDONTSMail.Send
set MyCDONTSMail=nothing
sampleyes.vbs
==================
Dim MyBody
Dim MyCDONTSMail
set MyCDONTSMail = CreateObject("CDONTS.NewMail"

MyCDONTSMail.From = "adminstrator@server.net"
MyCDONTSMail.To = "sampleDIST@list.server.net"
MyCDONTSMail.Cc = "backupadmin@server.net"
MyCDONTSMail.Subject = "Sample Update per Standing Request"
MyCDONTSMail.AttachFile("c:\cmdfiles\wrk\lavoz.xls"

MyBody = "Attached is the monthly listing " & VbCrLf
MyBody = MyBody & " in Excel format. Any questions, contact" & VbCrLf
MyBody = MyBody & "Adminstrator at 913-555-5555" & VbCrLf
MyCDONTSMail.Body=MyBody
MyCDONTSMail.Send
set MyCDONTSMail = nothing