S
stackhouse
I'm doing a MailMerge from an Excel spreadsheet.
The spreadsheet contains multiple rows of data but I want to filter out
some of the data.
Can I do this using the SQL Statement parameter? Something like SELECT
* FROM 'Sheet1$' WHERE 'Sheet1$.Row.Cell <> ""'?
The parameter now just has "SELECT * FROM 'Sheet1$' "
The spreadsheet contains multiple rows of data but I want to filter out
some of the data.
Can I do this using the SQL Statement parameter? Something like SELECT
* FROM 'Sheet1$' WHERE 'Sheet1$.Row.Cell <> ""'?
The parameter now just has "SELECT * FROM 'Sheet1$' "