Andrew oren
New Member
Project Description 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.
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.