J
Jay
Does anyone have any input on this oddity? I am using an Access macro
to run a query and send a file as an attachment. The query runs, the
xls is sent. On a few random occasions, the macro runs, attaches the
xls, and also attaches files that were sent previously via the same
process. If my naming convention for the file I intend to send is:
newfile.xls, these rouge files will be attached as newfile01.xls,
newfile02.xls etc.
The extra files are not located on the filesystem anywhere - I checked
hidden files, the OLK directory, etc.
So I'm curious about:
1. How this is even possible - I thought sendobject could only send
one file.
2. Given that it's obviously possible, where would sendObject be
getting these files and what might be happening to make it continue
past the point of completing the query and creating the proper xls
file.
Any feedback at all would be greatly appreciated.
to run a query and send a file as an attachment. The query runs, the
xls is sent. On a few random occasions, the macro runs, attaches the
xls, and also attaches files that were sent previously via the same
process. If my naming convention for the file I intend to send is:
newfile.xls, these rouge files will be attached as newfile01.xls,
newfile02.xls etc.
The extra files are not located on the filesystem anywhere - I checked
hidden files, the OLK directory, etc.
So I'm curious about:
1. How this is even possible - I thought sendobject could only send
one file.
2. Given that it's obviously possible, where would sendObject be
getting these files and what might be happening to make it continue
past the point of completing the query and creating the proper xls
file.
Any feedback at all would be greatly appreciated.