I am running an Output To Macro on a daily basis which outputs a number of queries. I want to specify the firts part of the filename but want the second part to be made up of the current date. e.g VG900000251104. Is this possible please?

Yes but not in a macro, you must use VBA

So confert the macro to VBA and change the name to include something like Format(date,'yyyymmdd')

Regards