View Single Post
 
Old 08-03-2019, 06:35 PM
srussell srussell is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Aug 2019
Posts: 6
srussell is on a distinguished road
Default

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}
Reply With Quote