Hi,
Tried searching but couldn’t find anything that helped.
I have inherited a macro that sends the active sheet as an attachment to a recipient (based on a pull down) via email.
I want to include additional attachments if a checkbox is checked (Linked to cell CA29).
The code below works, as in when you select the send button it sends the sheet to email as an attachment but the issue I’m having is,
The selection window pops up for you to select a file to attach whether or not you have the check box checked or not.
This is the section I added for additional attacents.
Can someone help please.
Bookmarks