Within ACCESS, Send a .mdb file with linked table as email Attachm

T

titlepusher

Any code suggestions on how to send a small .mdb database containing a linked
table as an email attachment from within an access application. I know that
I can send the linked table as an excel spreadsheet, but I would really like
to send the linked table's mdb file. To clarify: I'm running an access
application (app1). There is a linked table from another small access
database (data1) containing limited info. I would like from within the
access application (app1) to generate an email with the database (data1)
containing the linked table as the attachment to the email. The operator
does not need to be able to edit this in their email editor. This can
preferrably go directly to a preset email recipient, and then notify the
sender that it was sent and or stick it in their "sent box". I am not a
good coder at all.. thats why I work in Access.. But I can hack some
cookie-cutter code together if shown some samples and direction. Biting off
a bit more than I can chew and need some help. Thank you.
 
A

AB

FYI, if you're using Outlook you can't email an Access database. The.mdb
filetype is blocked.
 
T

titlepusher

I could create the file as a dbf. or other database type if needed. Or rename
it as .txt, send it, then rename it again back to mdb once received if it is
possible to make send any other file type from within access. ... why would
Outlook block the mdb file type?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top