Couple things that don't specifically answer your questions, but I think will get you to your ultimate goal in a faster and easier way:
1. I strongly recommend at least considering using dblibs. They're an extremely powerful way to create, organize, and reuse schematic and pcb symbols for components. There are several threads here discussing them and how to set up the backing database, which can be an excel sheet, an access database, or a full sql server. At the library file level, footprints and symbols are completely independent and are linked together in the database, so every single capacitor in your library can use the same schematic symbol, and every single 0603 capacitor can use the same footprint. Once set up, it's dead easy to create a new library component using existing footprints and symbols by simply adding a line to the database that references symbols and footprints you already have.
2. The bom report is fine for quick and dirty output, but outjob BOM outputs are way more useful. You can select which columns get exported and how components are grouped, filter what components are shown on the bom, and it all goes into an excel file based on a template you can customize. Once you have an outjob file you like you can add it to your default project template and use it over and over.