Hi all, is it possible to email a query to excel with filter already activated?
G Gismo Registered User. Local time Today, 18:06 Joined Jun 12, 2017 Messages 1,298 Aug 22, 2018 #1 Hi all, is it possible to email a query to excel with filter already activated?
Ranman256 Well-known member Local time Today, 11:06 Joined Apr 9, 2015 Messages 4,337 Aug 22, 2018 #2 No, either: Export that filters the data in the query,docmd.transferspreadsheet, Or Export all data, the use vb code to open the excel file, Then filter the data. But this way you need an option on What to filter. Option 1 seems easier.
No, either: Export that filters the data in the query,docmd.transferspreadsheet, Or Export all data, the use vb code to open the excel file, Then filter the data. But this way you need an option on What to filter. Option 1 seems easier.