I was experimenting with the DATABASE command I have seen in other posts but I keep getting an Error! Cannot open data source.
I even tried the full path name for the excel file because I couldn't get the FILENAME \p /../ to work for me.
Here is what I wrote (goes along with the data source file I posted earlier)
{DATABASE \d "C:\Users\Scott\Desktop\Mail Merge\event-feedback-sample.xlsx" \s " SELECT [first_name], [last_name] WHERE [FAVORITEPART] IS NOT NULL ORDER BY [last_name]" \l "15" \b "49 \h}
|