I have developed an Access database for a client.  It was first developed in

Access 97.



Part of the system exports a report to a file (using the DoCmd.OutputTo) and

then sends it as an attachment using their corporate email system (which is

Lotus Notes).



This worked fine until we upgraded the system to Access 2000.



The user is able to select one or more recipients for the report, and then

clicks the Send button.  The report is unique for each client, so the

process is as follows;



1) compile data in temporary table

2) export report to RTF file using DoCmd.OutputTo

3) email file to recipient

4) repeat Steps 1 - 3 for each recipient



Normally, the first report is emailed without a problem, but the second one

throws the error;



Error : 2046

Description : OutputTo command not available



Why has this suddenly stopped working in Access 2000?



Has anyone else experienced this?  What other options do I have for

outputting a report into an RTF file (think I already know the answer to

this one)?



Thanks in advance.



Phil