Excel Attach an excel file automatically to email with VBA
Hello, i was wondering if the following can be simplified using VBA ? Action I have two tabs in my excel spreadsheet. Tab1 and Tab2. In Tab2, Cell A1, I type "USA" VBA The VBA should then filter only "USA" in Column C in Tab1 Remove the other rows in Tab1 which is not "USA" Attach the Tab1 to Outlook as "xlsx" with an email body text "Please see attached" While doing it, I also do not want to lose the data in Tab1 ? Thank you very much already! Aude
This question generated 14 answers. To proceed to the answers, click here.