Use DoCmd.SendObject to send Select Query

G

GVR_Mike

Is this possible? Here is my code but it does nothing at all:

DoCmd.SendObject acSendQuery, "QueryName", acFormatXLS,
"(e-mail address removed)", , , "Subject", "Some Text in email message.", False

This works when I make a table and acSendTable, but it doesn't do
anything when it's a select query, not even an error message. I'm
using Access 2000.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top