I am new to macros and VBA. I built a macro by scraping a few bits of code I found online so this may look a bit messy but it is very close to working for me.
My macro basically takes a column in excel and pastes it into a new workbook in order to save it as a .msg file (opens in notepad as the...