i want to export a table in access table .
1. for example every day at 8.00 it create an output excel file.
2. Attach the file and send to a fixed email at that time.
regards
A learner
i want to export a table in access table .
1. for example every day at 8.00 it create an output excel file.
2. Attach the file and send to a fixed email at that time.
regards
A learner
One way to send is with SendObject method. Review http://www.fmsinc.com/MicrosoftAcces...endObject.html
The time automation is another issue and not so easy.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.