I need to tailor it just a little bit. When running the sub, I need it to do the following:
1) Save Active Workbook.
2) Fire some miscellaneous code (e.g. Call MiscCode)
3) Attach the active workbook in an Outlook email with the date time stamp included in the file name attachement.
4) Close ActiveWorkbook WITHOUT saving changes.
5) Screen focus should be on the email draft with the attached file.
Both of the codes below get me close to what I need. It just needs an expert’s touch to get it where it can meet my needs as described above. I attached an Excel file if you’re curious to see how the codes below work.