To me it seems, that the DROP TABLE command is invalid when saying "DROP TABLE TABLE ..."
Here is how you manually can try to uninstall and delete the tables,
BUT before doing this,
BACKUP your database:
If you have phpMyAdmin, delete the following tables via phpMyAdmin: mos_newsletter, mos_newsletter_letters, mos_newsletter_subscribers, mos_newsletter_sendletters. Go to table mos_components and search for entries called "Newsletter", "Newsletter management", "Subscriber management" and "Send newsletter", delete them. In your mambo installation find the folder /components/com_newsletter and /administrator/components/com_newsletter delete them too. That should do the trick.
Another thing you could try (if you don't want to use the above) is opening the file /administrator/components/com_newsletter/newsletter.xml and look somewhere at line 60 if there is a typo, e. g. something like this:
Code:
<query>DROP TABLE TABLE `mos_newsletter`</query>
which should look this way:
Code:
<query>DROP TABLE `mos_newsletter`</query>
Hope, this helps.
regards,
novocaine