>>What is your SQL Server version? If it's Enterprise version, you can set up data driven subscriptions.
>
>Its 2005. How would I tell if they have enterprise version or not ?

SELECT 
	SERVERPROPERTY('Edition') AS Edition,
	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel

from
http://berezniker.com/content/pages/sql/microsoft-sql-server/retrieving-sql-server-edition-version-and-service-pack-info