VB script for sending qv sheet by email

[linoyel]

Hey all,

In my QV document I have a VB script to send one tab that contains several objects by e-mail.

I created an on-open trigger (on post reload trigger doesn't work) in order to activate Macro.

The only thing that is not working is that it takes time for tab to load, but the email is sent right away after tab activation command - that's why I get email with only half-loaded data...

I tried different sleep commands in order to make the tab upload first and then save it to file (which is sent by email afterwards), but nothing works properly.

I also tried to open my document in client, but it didn't work either - I still got half-loaded mail.

I'll be happy to get any help

Thanks!