Sending Report via Email

  • Thread starter Thread starter ET Sherman
  • Start date Start date
E

ET Sherman

I have a database (Access 2000)that generates reports to
be emailed via Outlook 2000 SP3. I get the following
error message from Outlook sometimes when reports are of
a certain size:

"Could not open one or more attachments"

M/S Access creates a snapshot file then opens the default
mail program and attaches the report. It works fine
until the report is of a certain size then the message is
generated.

Any help will be appreciated.

Thanks,

ET Sherman
 
Please specify how you send the emails -- by VBA or outloo

MCP - Access and SQL Serve
----- ET Sherman wrote: ----

I have a database (Access 2000)that generates reports to
be emailed via Outlook 2000 SP3. I get the following
error message from Outlook sometimes when reports are of
a certain size

"Could not open one or more attachments

M/S Access creates a snapshot file then opens the default
mail program and attaches the report. It works fine
until the report is of a certain size then the message is
generated.

Any help will be appreciated

Thanks

ET Sherma
 
Thanks for the reply. I am using the following VB code
to handle this process:

DoCmd.SendObject acSendReport, "LoadSummary", "SnapShot
Format", , , , , , True

Note: I can run the database on my laptop (outside of
the customer's network/mail server) and it works
perfectly each time irregardless of the size of the
attachment). I can generate a report of 2,000 pages on
my laptop and it works just fine. The problem only exist
when the customer uses the application on workstations
and accounts going through their mail server.

Thanks,

ET Sherman
 
ET:

What mail system is your client using? Sometimes administrators specify
that attachments can only be up to a certain size. Consult with the mail
system administrator.
 
Back
Top