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.

This thread is current as of April 01, 2015.

For more resources for Microsoft Excel