email from excel 2

CLOSED
Bids
32
Avg Bid (USD)
$28
Project Budget (USD)
$10 - $30

Project Description:
Please see my posting from November 8. Same name.
I would like to have a second worker do it independently

Additional Project Description:
11/09/2013 at 12:24 EST
I need to email a list of patients to confirm their appointments. I get an excel spreadsheet with the patients' names, email addresses, time of their appointments and date of their appointments, among other columns of data.

I would like to generate emails to each individual patient, with a reminder that they have their appointment scheduled on the date and at the time that is indicated in the excel spreadsheet. I attached a sample spreadsheet, and obscured irrelevant fields.

I attach a copy of the email that I send. I would like the prefix (Mr./Ms.), last name, date and time of the appointment to be unique to each recipient, As I mention later, the subject should also contain the individuals' first and last name

I would like to automate the process so that an email to each patient, from the email address that I select is prepared and made ready to send, BUT NOT SENT until I review it and press "send"

The body of the email contains a hyperlink that they can press to acknowledge confirmation of their appointment.

The spreadsheet also contains the gender of the person; I would like to have the gender converted to Ms. for female (f) and Mr. for Male (m), so that the salutation of the letter begins,: Dear Mr. (or Ms.) ...., (person's last name)

I would also like the subject line of the email to read: Appointment Conformation for FirstName LastName.

Ideally, I can generate ALL of the emails on the list with one button, "Send Emails"

I have downloaded and included a code that I saw online on how to do this; i know nothing about code. if it helps, please refer to it, if not, please ignore it.

Finally, the report that I use will change form as it is being developed. I need the product that you develop to be able to allow me to specify which cells are to be used in the email, in case the body or setup of the excel report changes over time.

Skills required:
Excel
Qualifications required:
us_eng_1 US English - Level 1
Additional Files: sample schedule.xlsx confirmation 2.rtf confirmation 1.rtf
Hire rfmd1001
Project posted by:
rfmd1001 United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 35
in 1 days
$ 29
in 1 days
Hire best4best
$ 30
in 1 days
$ 54
in 3 days
$ 84
in 3 days
$ 25
in 3 days
$ 30
in 3 days
$ 30
in 2 days
$ 30
in 3 days
$ 30
in 3 days