Do some Excel Work
$30-250 USD
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.
Project ID: #10525292
About the project
40 freelancers are bidding on average $124 for this job
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
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
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
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
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
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
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
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
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
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
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
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