My company uses Bugzilla for issue tracking. Part of my responsibilities include handling customer emails for feature requests and issue resolution. If we intend to add/fix something the customer has brought up, I offer to add them to my release notification list so they'll know when it's ready. Currently, this is tracked by adding a "requested by User Name firstname.lastname@example.org" into a Bugzilla comment and adding a line into a spreadsheet that I have. The spreadsheet's columns will eventually automatically compose a mailto: link with info pertinent to the customer so I can easily email folks when we're ready.
The problem I'm having is that we regularly reassign tasks in Bugzilla from one release to another. I don't want to have to update the spreadsheet all the time, nor do I want to risk not notifying an interested customer and potentially losing a sale.
Is there any site that integrates with Bugzilla that will let me link up multiple user requests with a Bugzilla task and then pull a report based on a Bugzilla version number when I'm ready to send the notification? This would really only be used by me, so it does NOT need any interface for the customers themselves.
If this could be performed within Bugzilla, that would be great too, but I can't find a way to make it work. It doesn't look like creating custom objects or custom fields that only show up on a specific type of record is possible, from what I can tell.