Recent content by Phil_Child

I am running an Access 97 database on a Novell LAN with Groupwise 7 as the email client. One of the users enters a record on a form and hits a button that sends an email, using the vb SendObject command. It sends the results of a query in XLS format and works perfectly. The recipient (a...

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.

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...