Hi all,

First, I have a site that is still running the old DNN 2.1.2 that needs some new feature.  I need to send result of a SQL query via email to a dynamically built list of user emails.  The problem I'm facing is that the client is requesting this to be setup so that the emails are scheduled to send out automatically on the first of each month.  Does anyone know of any custom modules that I can use or share his/her own solution that is similar?  Would using the built-in Scheduler feature work for what I'm trying to do?  I'm having issues creating new or even viewing the details of pre-installed schedules.  I get the following error:

DotNetNuke.ModuleLoadException: One or more of the types in the assembly unable to load. ---> System.Reflection.ReflectionTypeLoadException: One or more of the types in the assembly unable to load. at System.Reflection.Module.GetTypesInternal(StackCrawlMark& stackMark) at System.Reflection.Assembly.GetTypes() at DotNetNuke.Scheduling.EditSchedule.GetTypes(Assembly TargetAssembly) at DotNetNuke.Scheduling.EditSchedule.GetAssemblyTypes() at DotNetNuke.Scheduling.EditSchedule.BindData() at DotNetNuke.Scheduling.EditSchedule.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

I can't seem to locate root cause of this error so if someone has experienced same and know a fix please also let me know.  Thanks.