I have a project with multiple different sheets where each sheet has a command button to send the sheet contents through an email automatically. One sheet, my macro adds an attachement to mail envelope, but if I were to go to a different sheet and send an email via mail envelope where there shouldn't be an attachement, the previous attachement from the complete different sheet is still attached. Am I missing something from my macro that removes this attachement after sending? Any thoughts on how I can resolve if not?
Bookmarks