Email excel with filter (1 Viewer)

Gismo

Registered User.
Local time
Today, 18:06
Joined
Jun 12, 2017
Messages
1,298
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
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.
 

Users who are viewing this thread

Top Bottom