SendObject Code Problem

[Joe Williams]

I am trying to use sendobject to automate the e-mailing of a snapsot report.
My problem is that when I run the sendobject command in code via a command
button, it takes almost 30 seconds for the report to generate and be placed
into a new mail message.

If I run the report manually OR set up the sendobject in a macro then report
runs and a new e-mail is generated almost immediately.

Why would calling sendobject fromcode slow down the generation of the
report?

 

[Joe Williams]

Nevermind, I figured it out! There were some DLOOKUPS on the calling form
that were giving an ERROR. So, sendobject must have been trying to resolve
this when opening up the report. As soon as I resolved the DLOOKUP errors,
the report and e-mail opened up without any delay.

Thanks
- joe