Slow SendObject statement

[mikemaki]

I have a SendObject statement:

clssendobject.SendObject acSendReport, "rptPolicyList", accOutputRTF, , , , "Children's Hospital & Health System - Policy and Procedure Report", "Please review the attached report.", True

When it is run in ACCESS 2003, it takes about 15 seconds. When it is run in ACCESS 2007, whether it is in the 2003 copy or the converted 2007 copy, it takes up to 40 minutes.

Does anyone know why and how I can speed it up?

 

[darbid]

I dont know why, but I have a theory.

It is not Access only that is at play here. As you can understand this uses Outlook to send the mail (or your mail client). So for your two tests are you using the same Outlook client?

 

[mikemaki]

Good point. It is two different Outlook clints.

 

[mikemaki]

I just changed the SendObject statement to an OutputTo statement. I thought it might be quicker to save the report to rtf and then sending it. The OutputTo statement is just as slow.

 

[mikemaki]

I found the slow down. It's exporting to rtf. Exporting to a snapshot or txt is super fast. Exporting to rtf or html is super slow.