SendObject Problem - blank attachments

[Phil_Child]

I am an old hand at using SendObject but this has me stumped.

I have created a DoCmd.SendObject procedure attached to a button. It is supposed to send the contents of a query (single record) in RTF format.

When the button is clicked it works perfectly on my machine, but when another user on the LAN clicks the button it sends the email but the attachment is received empty, ie no data.

Any ideas? Is this something to do with installed ActiveXs perhaps?

Many thanks

 

[KeithG]

What about if the user views the underlying query? Does it contain data?

 

[Phil_Child]

Yes, we've looked at that. The security permissions are set to allow the query to be run. I have just checked again and the query performs correctly with one record, regardless of who is logged in.