Em Andamento

email from excel

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.

I hope that this is clear

THIS PROJECT MUST BE COMPLETED IN ONE (AT MOST TWO) DAY(S)

Habilidades: Excel

Ver mais: use excel online, report from excel, names email, Excel report, excel automate, automate email, excel date reminder, automate report excel, copy email address, copy excel spreadsheet email, appointment setup, excel unique, send form data spreadsheet, automate excel code, send email confirmation, individual email, project report online patient appointment, email appointment, need female date, email letter, online excel report, automate online form, appointment email, send form data excel, crystal report send report excel email

Acerca do Empregador:
( 30 comentários ) new york, United States

ID do Projeto: #5108582

Premiar a:

expertatwork

hey rfmd1001, we rejected your previous projects due to lack of knowledge on H17 interfaces. However, this one is simpler and we can do .are you using WINDOWS ? please reply. thanks :-)

$28 USD em 2 dias
(44 Avaliações)
4.6

8 freelancers estão ofertando em média $26 para este trabalho

nazmulcb

Dear Sir, quality and expert researcher here. Spending time idle. Please give me an opportunity to doing this. I will do it accurately and honestly.

$30 USD in 2 dias
(17 Comentários)
4.7
pandey2008

Hello sir,i have 8 member team and good experience plz give us one chance we will do our [url removed, login to view] you..

$24 USD in 3 dias
(20 Comentários)
4.5
Edison1983

*****I've done a similar projects. Please refer the below link******* [url removed, login to view] Good Day!... I'm an Expert in Excel VBA Automation. Have developed & designed various Mais

$30 USD in 0 dias
(11 Comentários)
3.7
litebrain

Hi There, I can provide web based platform where you can import email lists with appointment dates, schedule your emails on a set date, create email campaigns etc. $30/mo.

$30 USD in 2 dias
(1 Comentário)
2.1
pachu11

La propuesta todavía no ha sido proveída

$25 USD in 14 dias
(4 Comentários)
1.4
saktulgasaktulga

I am an excel expert who can achieve the goals you specified in your project description in a very short time. Regards

$20 USD in 3 dias
(1 Comentário)
0.0
smadil997

.. ..

$19 USD in 3 dias
(0 Comentários)
0.0