Exporting data in batches to Excel

I am interested in automating a previously manual task, in order to do this I need to download current market data from Bloomberg for multiple securities and export this to Excel in one go. This in turn means that the Bloomberg Excel-Add in is not appropriate because this tool can only access one security at a time.

Any advice on the script I would have to write in order to perform this “batch download” is much appreciated.

p.s – I started Python very recently so any introductory information is also appreciated