SQL, Access, Email Project.

This project was successfully completed by fastudiovw for $50 USD in 3 days.

Get free quotes for a project like this
Project Budget
$50 USD
Completed In
3 days
Total Bids
Project Description

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.

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online