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

Similar Threads:

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

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?

"AB" wrote:

> FYI, if you're using Outlook you can't email an Access database. The.mdb
> filetype is blocked.
> 
> "titlepusher" < XXXX@XXXXX.COM > wrote in message
> news: XXXX@XXXXX.COM ...
> > 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.
> 
> 
> 

2.Send an email from access app with linked table's .mdb as attachme

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.

3.Sending data to Access MDB Table?

Excel 8.0
I would like to be able to send data from within an Excel function to an
Access log.
e.g.

UserName  ' Network Log-in Username - I presume I can use the same code to
obtain this as I use in Access?
Date and Time ' the current Date and Time
ReportType ' a short text string

The Access MDB is named "Reports.mdb" - the Path would be to a network
destination e.g. "\\server1\Reports\Reports.mdb"
The table in Reports.mdb is named "tblLog", with the field names "User",
"DateTime", "ReportType"
The transaction would need to be discreet, in that it can occur in the
background without user intervention - a weekly event that's all.
Is this possible?

Any help gratefully appreciated

WSF

4.Cannot import send/receive dates for emails stored in Access (.mdb) file

I have some mdb (Access format) database files with thousands of emails
extracted from couple of Yahoo groups forums.  I'd like to import these
into my Outlook 2003 PST so that I can search and read them offline.

The mdb files contain all the fields necessary for a proper email
import, including

from_name
from_email
subject
receive_date
receive_time
message (HTML format)

When I use the Outlook "Import and Export Wizard", selecting Access
file type, etc., all appears fine.  However, after the import
completes, in Outlook there is no date information populated under
either sent or received date.

If I use the "map custom fields" button on the import wizard, all of
the import file fields are shown correctly on the left hand "from" side
(as listed above) but on the right hand "to" side I only see the
following Outlook fields to map to:

subject
body
from/to/cc/bcc (name)
from/to/cc/bcc (address)
from/to/cc/bcc (type)
billing information
categories
importance
mileage
sensitivity

For whatever reason, THERE IS NO DATE FIELD to map to.

I can map date to something like "billing information" but that doesn't
help much

I appreciate any help or advice you can provide!

Thanks,

John

5.Two tables - Send email using link to other table where email address stored

Hello

I have two tables,

1.  Employees which links to Sales

The two tables have a [Name] field in common.

On the sales table I also have a check box.

I have a main form being the employees and sub-form being the sales.
There is also a combo box which lets me filter down.

What I wanted to do using the form is when I click on the check box on
the sales sub-form it will lookup the [email] field in the employee
table and then send an email.

I hope someone can help with this as it's causing me lots of issues,

Thanks so much

Andrea

6. Body of Outlook email stripped out when using "send as attachm

7. Opening access .mdb file sent by email or on diskette

8. Error created linked tables from one .mdb to another .mdb