I have to create a form in Excel 2007 that will contain a button that does two things; (1) combine form cells to create a unique file name and save it on our server, and attach the saved form to an Outlook email recipient (ex: John Smith). Attached is my work-in-progress.
Questions I have:
1) the button is supposed to combine several cells but I keep getting an error...why?
2) one of the cells that the button is supposed to use is a date(cell B1) but I want the file name to begin with this format YYMMDD instead of MM/DD/YYYY. How? For example, "151106 Sample 1 Moldy Product"
3) how can the button also (1) open Outlook (2) addressed to John Smith (3) with the file attached (4) and the subject to read "New Incident Report 151106 Sample 1 Moldy Product" if the date modified = the Date Reported on the form in cell B1, but if the date modified is not equal to B1 then it means the file was updated so we need (1) Outlook to open again (2) addressed to John Smith (3) with the file attached (4) and with the subject to read "Updated Incident Report 151106 Sample 1 Moldy Product".
I love learning from you pros and thank you in advance for all your help!!!
Bookmarks