I have this excel spreadsheet that will be passed back and forth between my supplier and me. This list has consigned material and all we do is put in the date when material is pulled. I would like to set-up a macro that at the end of the day will send email of this form back to the supplier and will also send email to our AP department showing what material was pulled for the day. A simple click of the button. I am familiar with doing this in access, but not excel.
Any help would greatly be appreciated.