Today, there is an insignificant difference in fuel consumption between new automatic transmission and manual transmission cars. Older automatic transmission cars, on the other hand, usually consume much more fuel.
However, fuel consumption is affected more by your driving style than your car's type of gearbox.