Delete a Temp File Stored On Hard Drive Access 2007 VBA

[Jeff Garrison]

All -

I'm outputting a report to a user's hard drive using Access 2007, so that I
can attach it to an email. Side bar, I know I can send the report using
SendObject, but I'm doing it this way so that I can programatically send
multiple attachments on one E-Mail. I can output the report, but I'd like
to delete it after the e-mail is sent. How can I delete the outputted
report off the user's hard drive using VBA?

Thanks

Jeff

 

[Albert D. Kallal]

The command in vba is

kill "full path + file name goes here"

 

[Jeff Garrison]

Thanks....I didn't realize it was something as simple as that...