I gang

write an Excel program that interfaces with Outlook and Word

PLEASE READ AND REVIEW CAREFULLY TO MAKE CERTAIN THAT YOU CAN PERFORM THIS TASK

I currently have a fully functional program written in Excel that:

- imports reports (.rtf) from my business program,

- populates the fields in Excel with the data

- generates emails based on the imported data

- allows the emails to be reviewed and sent individually or

- allows for a mass emailing without reviewing each email.

- if the patients' prefixes (Mr./Ms./etc) are not in the data, the program will convert the patient's gender to Mr. (male) or Ms. (female)

The program allows me to:

- choose which email address I wish to send the emails from

- send delayed emails

- request or not request return receipts

Entries with no email addresses are passed over automatically.

A report of patients (entries) that did not have an email transmitted is generated.

Unfortunately, this program is password protected and the programmer is in the Ukraine and unavailable at the present.

I would like to recreate this program so that:

- I have full access to its programming,

- can have it accept different .rtf reports, since the reports are constantly being changed, or I would like to add new/different reports with different

I currently use variations of this program to:

1. confirm upcoming appointments

2. send out recall reminders

I will attach the programs that I have and a demo of how they work.

I would also like to build on this technology to create a new module that also imports a .rtf report into an Excel file and creates emails and Word documents based on additional variables that the user inputs in select cells. In the end, when the reports and emails are generated they are printed and/or sent with the same system.

"recall module" is the program I described in the beginning. It is used to confirm appointments and to send patients follow up reminders

"example of recall module" is an illustration of how it works

"results module" is a conceptualization of the second program; it does NOT exist

"demo of reports module" is an illustration of my objectives for the "results module"

Again, please review what I am requesting in detail and respond / bid appropriately.

Because I already have a functioning system, my budget is fairly limited. Thank you.

Færdigheder: Excel, Microsoft Outlook

Se mere: programmer excel add programming, outlook programming, outlook delayed email, microsoft programmer, microsoft excel programmer, microsoft email business, illustration programs, write programming excel, write written report, write thank email, how outlook, excel add programming, excel access programming, delayed email outlook, business report write, business conceptualization, microsoft excel programming, write task, read review, program written, microsoft access business, excel word outlook, convert access reports, excel convert access, excel file convert

Om arbejdsgiveren:
( 30 bedømmelser ) new york, United States

Projekt-ID: #6047014

Tildelt til:

koolsidz

Hello :) I am a VBA / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not Mere

$166 USD in 5 dage
(110 bedømmelser)
6.0

5 freelancere byder i gennemsnit $204 for dette job

abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database Mere

$263 USD in 5 dage
(5 bedømmelser)
4.8
ExcelManipulator

A proposal has not yet been provided

$188 USD in 15 dage
(3 bedømmelser)
1.8
emiliatech

Dear Hiring Manager, My name is Pooja Arora. Currently I am managing a team of data entry experts. Typing speed is 40 words per minute with an accuracy of 100% and having strong command over all the Excel formulas. Mere

$144 USD in 3 dage
(1 bedømmelse)
0.0
pbankar

Hi, I have worked on such projects for few of clients and also worked on Excel macros, pivot tables, data filter, conditional formatting, vlookup, macros, VBA, etc. I would like to work on this assignment. Looking Mere

$155 USD in 3 dage
(0 bedømmelser)
0.0
eonaman

I am not sure if you have tried your luck unprotecting the sheet using available free tools in internet? I am a VBA guy, I read through your requirement and can re-create the sheet if we can work together..some of t Mere

$250 USD in 3 dage
(0 bedømmelser)
0.0
undersky1230

Hi. I am an macro expert, and I master outlook. I almost understood your project. I will satisfy you. I will do it within 3 days. Best regards.

$250 USD in 3 dage
(0 bedømmelser)
0.0