Closed

email from excel 2

Please see my posting from November 8. Same name.

I would like to have a second worker do it independently

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: Excel

See more: excel email address text, excel email urls machen, automate excel email, excel email blast, excel email pivotable, excel email script, asp form excel email, automated excel email, automatic excel email, excel email automatic

About the Employer:
( 30 reviews ) new york, United States

Project ID: #5110784

28 freelancers are bidding on average $29 for this job

Kamalkishover

Hi We have done similar project, We have expert team. WE provide you quality work as per your requirement. Ready to start Now. Thanks

$35 USD in 1 day
(95 Reviews)
5.9
noushin24

Hi, After reading your project description. I am willing to do this job for you and ready to work immediately, following your instructions. Kind Regards, Noushin Jahan

$29 USD in 1 day
(26 Reviews)
5.3
best4best

I could not see your posting on November 8. Please can you let me know your requirement. I assure you for accurate work.

$30 USD in 1 day
(61 Reviews)
5.1
fhasanbd

A proposal has not yet been provided

$54 USD in 3 days
(45 Reviews)
5.1
srinichal

I can deliver a macro for your needs and code it to your specifications .

$84 USD in 3 days
(6 Reviews)
4.9
wannaBbest

Hello Look up someone's profile is restricted by freelancer.com. So can you send details for further discussion? Thanks. Regards, Raaz

$25 USD in 3 days
(19 Reviews)
4.7
jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am amo More

$30 USD in 3 days
(26 Reviews)
4.6
SoftwareEng8876

Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [url removed, login to view] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..

$30 USD in 2 days
(13 Reviews)
4.4
flashsaiful

Hi dear Sir, I can do this for you.... ..thanks

$30 USD in 3 days
(25 Reviews)
4.2
KGMNA

Dear sir, Ready to start your project. Please send me more details. Waiting for your positive reply. Best Regards KGMNA

$30 USD in 3 days
(13 Reviews)
3.8
TypingxpertRehan

can you send me the link of project. i am ready to do the job . Waiting for your positive reply.................

$14 USD in 2 days
(10 Reviews)
3.7
Edison1983

***********I've done a Similar Project. Please msg me i'll show you the project in the team viewer.**** After then, If you are OK to proceed with me, I'll be glad to assist you always. Looking forward from you.

$35 USD in 0 days
(11 Reviews)
3.7
rumapaul

Hello Greetings Shall we discuss about the project Kindly upload the yesterdays project description Waiting for your reply Thank You Regards Ruma Paul

$25 USD in 3 days
(4 Reviews)
2.7
wishr

I am good in excel work. Let me know if i can help you. But i cant find the work details in your profile.

$35 USD in 7 days
(4 Reviews)
2.5
sabirshah4545

Dear sir i will do it thanks..................................................................................................................................

$23 USD in 3 days
(2 Reviews)
1.9
arunnama001

hello sir send me full details of your project i can complete your work on time i am waiting for your response..... Thank you sir for full update i understand your project i will send email in proper format in stran More

$25 USD in 3 days
(2 Reviews)
1.8
nsbd1988

Hi, I have gone through your requirement. It seems easy for me to work on this project. i am very much interested to start this project right away. I am ready to discuss more about the project. I am offering you the mi More

$23 USD in 3 days
(2 Reviews)
1.7
tarunprodhan

Dear sir, Ready to start now! After read the project description, I’m sure that I can do this job very fast and accurate. I hope you will consider me for this job and I can start immediately. Thanks.

$24 USD in 3 days
(3 Reviews)
1.6
webseofaqs

Hi guys I am self motivated, Professional and honest SEO services provider. After use my services you ll say you got what you needed! Only White hat and manual services. More than 4 years experience in SEO field. Pl More

$35 USD in 3 days
(4 Reviews)
1.1
vcare77

Dear Hiring Manager, I can do this job efficiently and effectively Have a great day to you, I am interested to do this job and please see my elance profile link [url removed, login to view] More

$20 USD in 2 days
(3 Reviews)
1.1