Try converting the macro's to VBA by using the conversion wizard then make
the corresponding changes and additions maybe a timer between actions

-----Original Message-----
From: Vinay Poddar [mailto:vinay.poddar@s...]
Sent: 26 March 2001 13:55
To: professional vb
Subject: [pro_vb] Help requiren on MS Access 2000.






Our Access application consists of generating reports for various Districts
and
then e-mailing the reports corresponding to each District to a District
Admin.
We are making use of macro commands 'openreport' to generate reports  and
'sendobject' to attach these reports to an  e-mails which is then sent
automatically. This macro is named autoexec and automatically receives
control
when its parent database is opened by another database thru the RunApp
command.

Problems are:
1. The generation of the report goes into infinite number of pages for the
first
report when the SendObject starts to execute
2. The report is not attached to the mail sent to the first District,
irrespective of which district it is. The attachments are correctly sent to
every subsequent district.
This entire Macro however runs perfectly fine when executed by itself
without
the transfer of control as described above.

If any body have faced similar kind of problem and can help , please come
forward.

Vinay