I have a form that I have created in excel that I want to create emails based on a certain cell that is selected.
Basically when they select a certain position I have Vlookup bringing over information and populating fields about that position. One of them is a supervisor field and I have thier email addresses in the workbook as well. When they have completed the spreadsheet I wish for them to email it to the next person in the chain of command. I want to embede a button at the bottom of the spreadsheet that when pressed will pull up a template email in outlook that will create a Subject line of the email based on certain cells within the workbook.
I also don't want them to be able to make the selection of the "email button" until they have filled out all required cells.
Any thoughts? As obvious from my wording I am an excel middleby- as opposed to newbie, but I do not use the correct terminology. Any help would be aapreciated.
Thanks,
Broddick
Basically when they select a certain position I have Vlookup bringing over information and populating fields about that position. One of them is a supervisor field and I have thier email addresses in the workbook as well. When they have completed the spreadsheet I wish for them to email it to the next person in the chain of command. I want to embede a button at the bottom of the spreadsheet that when pressed will pull up a template email in outlook that will create a Subject line of the email based on certain cells within the workbook.
I also don't want them to be able to make the selection of the "email button" until they have filled out all required cells.
Any thoughts? As obvious from my wording I am an excel middleby- as opposed to newbie, but I do not use the correct terminology. Any help would be aapreciated.
Thanks,
Broddick
