Emailing from Access Basic/macro where mdb file is the attachment

[Guest]

I need to send a access mdb file containing a linked table. It needs to
become an attachment to an email. I know that I can run a macro to send a
table as an excel spreadsheet or rtf etc... but I need to send the actual mdb
file. Probably will take some coding which i am very lame at but can
manipulate some cookie cutter stuff if shown where to start. I would like to
execute this from a macro or at least run a macro at the end of the code to
continue other functions from the same button.

 

[Arvin Meyer]

I need to send a access mdb file containing a linked table. It needs to
become an attachment to an email. I know that I can run a macro to send a
table as an excel spreadsheet or rtf etc... but I need to send the actual mdb
file. Probably will take some coding which i am very lame at but can
manipulate some cookie cutter stuff if shown where to start. I would like to
execute this from a macro or at least run a macro at the end of the code to
continue other functions from the same button.

Access Basic died with Access 2.0 and became VBA. They're not that much
different from the Access Basic side, but tremendously different in the
power of VBA. You can email a file with ease from the code on my web page,
but you don't want to try emailing the file from within its own code. See:

http://www.datastrat.com/Code/OutlookEmail.txt

Make sure you are emailing another database because you can easily corrupt
any open file by trying to email, zip, copy, or otherwise manipulate it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access