The Met Office has apologised for the blunder which it put down to an error when test alerts issued by a third party aggregator were accidentally sent to the public.