I wish to have excel send an email to a contact email address (already entered in the worksheet) whenever I enter a date for each step of the job process.
For each process, an automatic email will be sent which updates the client that on "X date" the "X step" has been completed for their job. I will provide the "standard" verbiage to be used as the body of the email.
To be clear, when i enter the date for a particular step in the job process an email will be compiled that includes the date entered, the step completed and standard verbiage. This email will be sent to the contact email for that job (entered in the worksheet) each time I enter the date in the particular date fields.
I can send the excel file with the basic Column setup I want. I also need to be sure that I can continue to expand the sheet as I add more jobs without losing functionality.
I know very little about excel but enough to know this is possible for someone who knows what they are doing.
23 freelancers are bidding on average $140 for this job
Hello, I’m an Excel/VBA expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
I am working on such excel sheet with all the requirements you are looking [login to view URL] be completed in an hour or so. Can provide you the sheet.
Hi I would suggest adding a VBA code into the excel that will do the emailing action on daa entry. the email will be either sent directly or via outlook or other mail client. david