Do some Excel Work

Cancelled Posted 7 years ago Paid on delivery
Cancelled Paid on delivery

I need a spreadsheet which has some Visual Basic functionality programmed in.

The spreadsheet will have the following column headers.

Name, ID #, Date of Birth, Age, Gender, Review Date, Outcome, Outcome ID#, Distance, Stage 1 Date, Stage 2 Date, Stage 3 Date, Mailed, Called, Dx, Reason, Location, Comments.

The spreadsheet should also have a macro button on top of spreadsheet which says "Send Reminder Emails." I'd like the button to activate a VB script which reviews the dates in the "Stage 2 Date, and Stage 3 Date" columns. When the date in either column comes within 2 weeks I'd like the script to generate a reminder email to my outlook email. The email subject line should be, "2-Week Appointments - Review Required."

The email should contain an easily readable reminder which contains all of the data elements in the row (with the appropriate column headers above). The reminder should state, "Please review the following accounts for upcoming eligibility." The data elements can be in table form or free-text, whichever looks the most readable/user-friendly.

I specifically want this macro/VB script to only run if I manually press the macro button on the top. I do not want it to generate upon opening the file.

Data Entry Data Processing Excel

Project ID: #10525292

About the project

40 proposals Remote project Active 7 years ago

40 freelancers are bidding on average $124 for this job

Khurramz

Hi, So you don't want the script to send emails automatically, right ? .

$250 USD in 5 days
(422 Reviews)
7.8
mehedi276

"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed se More

$144 USD in 3 days
(467 Reviews)
7.5
elqueabandona

Hola, mi nombre es Cristian, soy Licenciando en Administración de Empresas y trabajo con Excel todos los días. Tengo mucha experiencia con hojas de calculo, formulas, modelos y macros. Observa mis calificaciones, More

$150 USD in 3 days
(311 Reviews)
7.4
fatimatuzzohura

Hi, I have read the project and understand your requirement.I am a highly trained on Data Entry ,Research, Web search, Web scraping, Product Add, Any Type Of eCommerce Cart, Expert with great knowledge of Excel. I also More

$155 USD in 3 days
(198 Reviews)
7.0
cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please More

$150 USD in 2 days
(201 Reviews)
7.2
maverick44000

Hi Sir, I have this this exact same work before. I can write the required VBA script with in a day. Please discuss so we may proceed. Thank you, Usman

$110 USD in 1 day
(70 Reviews)
6.9
flashsaiful

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$155 USD in 3 days
(170 Reviews)
6.8
beltran0404

Hello, I would like to help you on this. I'm excel developer and manage macros. If we work together I will make this helpful application for you. I hope hear from you soon! Regards, Luis Romero

$50 USD in 7 days
(173 Reviews)
6.1
shafaqat11

Dear Hiring Manager, I am expert in Excel. I understand your job and very much excited to offer my services for your job. Please feel free to contact me directly to discuss this position further. I am all time onlin More

$122 USD in 3 days
(107 Reviews)
6.2
bhupendrayadav

I am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Excel, VBA. Currently working in an MNC Analytical company on a large financial model including dashboards and presentation More

$130 USD in 2 days
(51 Reviews)
5.9
archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a reservation system - Build a complex shift allowance c More

$100 USD in 3 days
(84 Reviews)
6.0
saminatinny

A proposal has not yet been provided

$88 USD in 3 days
(49 Reviews)
5.5
prabakarm23

I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I More

$155 USD in 3 days
(50 Reviews)
4.7
abhi1326

Hello I understand that you are looking for someone prepare a macro for the data in your excel sheet to send automatic mail reminders. I have worked on Excel projects for other clients as well and delivered quality More

$80 USD in 5 days
(10 Reviews)
3.8
cwashingt

Microsoft Office: Word-Advance Excel-Advance PowerPoint-Advance SharePoint-Intermediate Web Research-Intermediate/Advance Blog, Creative Writing, Content Writer-Intermediate (Writing since grade school) All wo More

$155 USD in 3 days
(0 Reviews)
0.0
andreworen

This will be a quick fix. if I hear from you in the next 1.5 hrs I can get it to you from my office here at work be done by 8pm. otherwise if I hear from you after that you can expect it by midnight tonight the absol More

$125 USD in 1 day
(0 Reviews)
0.0
martinndunford

The Data Entry Specialists Hi dear, I’d love to work on projects: Data Entry Jobs Copy Typing Jobs Web Research Jobs Ms Office Jobs Including Word, Excel…. Hope you are fine and doing well. After re More

$200 USD in 15 days
(0 Reviews)
0.0
sheebarajendran

A proposal has not yet been provided

$50 USD in 3 days
(0 Reviews)
0.0
fchiniot

Hello Sir, I know how to work on ms word .i competed different computer courses . love to type copy paste.i have experienced that work . i do this daily. i will comlete your work very soon and fastlly . i,m able to u More

$111 USD in 3 days
(0 Reviews)
0.0
mohammedfadel

A proposal has not yet been provided

$55 USD in 3 days
(0 Reviews)
0.0