I have a macro that is designed to send an email with built in text based off cell references. It will copy a table that has a variable range based of another macro that runs first. My problem is, when the table pastes, it pastes into the Excel Spreadsheet instead of the new instance of an outlook email. I tried to build in a time delay to give the outlook window time to open. This has helped but it still errors sometimes and pastes the table on the spreadsheet.
Here is my code. Please help!
Thank you!
Bookmarks