Yes I think the Keywords field would work for this, and that's a tag written to the file as well. I didn't notice that one. I can probably implement that in MM before I import into MC.
The report is a VBS script that is run from MM which then exposes the Application Object in MM.
The report file is written to a file in the RTF format where I can control pagination and a few other RTF codes.
So page one of the report is for Box 1. Here's how it starts out. Each Box is written to it's own page.
***** Box #1 **********
ARTIST NAME ALBUM NAME
2 Unlimited No Limits
A. J. Croce A.J. Croce
Acoustic Alchemy Blue Chip
+Natural Elements
+Reference Point
+The Beautiful Game
+The New Edge
Adele 21
Air Supply Greatest Hits
Al Di Meola Kiss My Axe
Al Jarreau All Fly Home
Alabama Twentieth Century
Alan Jackson Good Time
America America
Also, I use ClickBook by Blue Squirrel to print it out as a 5 1/2 x 11" booklet. So all in all it's a nice archiving process to stow away my CDs since I never play them anymore just the digital copies.
some sample code from the script;
Select Case record_type
Case 1
'Just the classical and christmas, Box 10
sql = "SELECT DISTINCT Albums.Artist, Albums.Album " _
& "FROM Albums INNER JOIN Songs ON Albums.ID = Songs.IDAlbum " _
& "WHERE ((Songs.Genre LIKE '%Classical%') " _
& "OR (Songs.Genre LIKE '%Christmas%'))" _
& "AND (NOT (Albums.Comment LIKE '%Download%') " _
& "OR NOT (Albums.Comment LIKE '%Cassette%') " _
& "OR NOT (Albums.Comment LIKE '%Missing%') " _
& "OR NOT (Albums.Comment LIKE '%Vinyl%')) " _
& "ORDER BY (Songs.Genre)"
boxnum=10