Two thinsg to note:

1) I too had trouble with the DROP Table statement until I used the slanted quotes.  I accidentally discovered that I could also use Brackets to get it to work like this:

DROP TABLE [Authors]

2) I can;t get the ActiveX code to work with the objMail.AddAttachment line.  If I remove that line then the code works but when that line is there I get the error that the object doesn't support this property or method.  ANy ideas?

Thanks