>>>>>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
>>
>>Standard edition
>>
>>Version 9.00.4053.00
>>
>>Product Level SP3
>
>I see, this option is out then :(
>
>BTW, this is step by step instructions as how to set them up
>http://msdn.microsoft.com/en-us/library/ms159150.aspx

Thanks Naomi.

I think database mail may be the way for me for now.