Email Table missing

[TheOracle]

Did you export your customers email addresses before applying the upgrade ? There's a contribution in the downloads section of the site you can use to export your emails by only minimal clicks.

If you have backuped up your whole store, restore backup and try again. Otherwise, there isn't much you can do regarding this unfortunite event.

[BlushFashions]

I have had new customers since then so have email addresses the problem is hard to explain without seeing it.
Before if I wanted to email from the site I would be presented with what looked like a table and options to to, for example whne sending newsletters, to pick all customer, all subscribed customers etc etc.
Now all I get is this

1146 Table '*****.TABLE_CUSTOMERS' doesn't exist
in:
[select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS order by customers_lastname, customers_firstname, customers_email_address ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

It looks like a file or some code is missing.I am hoping it is somethign very simple to put right!

I have deleted file name just in case.

[TheOracle]

There must of been something wrong that happened during your last upgrade operation. If you go to your phpmyadmin, can you see your customers table ? If not, I'd highly suggest to restore backup and try again.

[BlushFashions]

Hi
The customers table is in the php, so not quite sure what has gone wrong there?
Maybe it is just something simple but I don't want to tweak anythign when I don't really understand what I am tweaking. What should it look like , the settings etc