Find Jobs
Hire Freelancers

Access 2007-MS Word 2007 Mail Merge Project

$30-250 USD

En curso
Publicado hace más de 11 años

$30-250 USD

Pagado a la entrega
EXECUTIVE SUMMARY: OUR ACCESS 2007 DATABASE HAS BEEN DESIGNED AND BUILT. (1) I need a simple way to query and store the information for all the letters we send to our donor base, (2) be instructed how to use it, and (3) have you clean up some of the tables and forms that were created, but that are not really necessary in this database. OPERATIONS OVERVIEW: Promise Ministries International is a Michigan based, Christian non-profit Bible college level ministry to American prisoners supported by the tithes and offerings of those who believe in what we are doing. Our student applicants provide us with names and address of friends and relatives that we contact through 4 or more different fundraising letters we send in a series. Each fundraising letter we send has the prisoner's name and a FREE book offer with each donation which we need to track when sent. We track these letters and dates sent to donors along with any of our dozens of books or other merchandise we send. TRACKING THE MONEY: When money (offerings) arrives, it has a purpose: to enroll or provide a student with any of our 5 separate Bible study programs (we are developing more); to provide a student with a Bible or a book (we have access to hundreds); or the money is to be used to pay for a degree; or it is to be used for any other miscellaneous purpose. AFTER POSTING OUR PROJECT we contracted with a Freelancer to build an easy to use, easy to navigate and edit Access 2007 Database to keep track of donors, donations and the purpose of the donations, all fundraising letters and thank you receipt letters we send along with merchandise requests and shipments. Unfortunately, while our Freelancer seems to have built us an easy to use Access 2007 db, instead of using Access queries from tables or what have you to store and track totals we require for our outgoing letters- as I requested- he chose to use Excel which is not what I wanted and very confusing to use. HERE'S WHAT I NEED YOU TO DO: FIRST: Using our existing Access 2007 db, I need EASY TO USE INTERFACE with queries you will write to allow me to export specific data from my existing Access 2007 database that I can quickly and easily merge into MS Word 2007. I'll try to explain. We track our letters and merchandise shipments to donors and students by dates. When the mail merge is executed, I want to pick a donor from the database, and a date or date range. I need the query to give me all the donors' details (name, address, prisoner they support, their relationship to the prisoner, etc, for our fundraising letters. For our thank you receipt letters, I require the same info along with money they gave or have given which I need separated and accessible by daily, weekly, monthly and yearly donations totals, based on the date I selected at the start. And I will need this for 2013, 2014, 2015, etc etc on into the future. CREATE SIMPLE INTERFACE: I want this to be EASY to use and to MAIL MERGE INTO WORD 2007, perhaps by CREATING an interface in Access or a button I can click. Again, please note: I don't want to use Excel, I want to use Access 2007 and MS Word 2007. SECOND: I also want to be able to print mailing labels or envelopes and/or lists of selected donors, gift dates, gift amounts, prisoner names, groups, etc from MS word, items (merchandise) sent, etc. I also want the ability to print a donor directory from Word. THIRD, I will need you to look over the database and clean up all the unnecessary components my Freelancer left when he finished. FINALLY, I will need you to train me how to use this as well as change query codes that will allow me to alter and manipulate data. I have the db available and ready to view and I'm anxious to get this project completed. Thank you.
ID del proyecto: 4014512

Información sobre el proyecto

6 propuestas
Proyecto remoto
Activo hace 11 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
6 freelancers están ofertando un promedio de $342 USD por este trabajo
Avatar del usuario
Hello, we are a group of programmers based in Sheffield, UK offering 7 years experience in php, .net, c#, jquery, css, python and c++. I am proposing to carry out tasks required for this project and deliver it within 48 hours. What you need is a shared add-in or a pair of vsto add-ins. We have created few in the past.
$599 USD en 2 días
4,9 (47 comentarios)
7,2
7,2
Avatar del usuario
Hi We can do it perfectly. Cheers, Al
$250 USD en 14 días
5,0 (70 comentarios)
6,3
6,3
Avatar del usuario
Please check your PM.
$350 USD en 4 días
4,5 (12 comentarios)
5,1
5,1
Avatar del usuario
Is it OK, if I wrap the application or tools into a MS Access addon so you will have a button or two for triggering the mail merge, configuring or setting the required fields for mail-merging purpose, manage the database, etc? Let me know so I may provide you a simple demo for this application. This will work on MS Access and MS Word only.
$200 USD en 3 días
4,3 (16 comentarios)
4,7
4,7
Avatar del usuario
Hi, I can do the job, MS Access, MS Word, SQL, PL/SQL expert. I understand your requirements, and also I worked in similar projects Regards Diego
$250 USD en 5 días
5,0 (7 comentarios)
3,9
3,9
Avatar del usuario
Hi, I have more than 7 years experience and build lots of databases in Access. I can complete this job according to your requirements and within the given timeframe.
$400 USD en 15 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Battle Creek, United States
5,0
3
Forma de pago verificada
Miembro desde nov 15, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.