In Progress

SQL, Access, Email Project.

SQL Server 2008 backend with MS Access 2010 Frontend.

On the form “frm_CLIENT” there is a button “Email Active List to Each Supervisor” when I click that I want to automatically send out a group of emails. One email to each supervisor for the active company.

So there needs to be a loop through the [SupEmail] field in the tbl_INFO for the current [Client]. For each [SupEmail] there would be a 2nd loop through all of the [Active] records in the same table.

I want an email sent to each supervisor [SupEmail] with an excel attachment showing all of the [Active] records for that supervisor. The excel sheet needs to include the [Fname] [Lname] [Group] [Misc_1] Fields. Also a small message like “Here are your records”

Error checking for possibly [SupEmail] could be blank OR maybe a non-email based data. Ignore those active records.

I have attached a sample database. Open “frm_CLIENT” the 3rd record is “WALMART” when this project is done and I hit the button 3 emails should be sent.

So a couple loops through the same table, an email for each result in rs1, with an excel attachment with data from rs2, then move to the next rs1. ect.

Skills: Visual Basic for Apps

See more: access group, ms sql client, ms access sql, ms access 2010, SQL Access, ms access email, move sql, excel with sql server, checking email, server 2008 email, sql server 2008 access, sql server attachment, excel access table, excel sample project data, sql maybe, sql server access excel, send email based data sql server table, 2010 access client database, access 2010 project, want email project, sql server database project, excel table 2010, loop table, sql move data, access backend frontend

About the Employer:
( 69 reviews ) United States

Project ID: #4886070

Awarded to:

fastudiovw

Hired by the Employer

$50 USD in 3 days
(100 Reviews)
5.9