Casino City’s Gaming Business Directory CD 13 Using Microsoft Query with Microsoft Word Mail-Merge Using Microsoft Query with Word mail-merge enables you to easily construct sophisticated queries to select an appropriate set of Gaming Business Directory data. Select Mail Merge on the Tools menu to open the Mail Merge Helper dialog box, click on Get Data under Step Two after setting up the main mail-merge document, and then click on Open Data Source. The Open Data Source screen will appear. Click on the MS Query button to select data using the Microsoft Query tool. Microsoft Query is an optionally installed component of Microsoft Office, so you will only be able to use it if it has been installed. The first screen presented by Microsoft Query is the Choose Data Source screen. If the Gaming Business Directory data you are using is in comma-separated values format, you must select “<New Data Source>” and click OK. Data downloaded from GamingDirectory.com is always in comma-separated values format. The Create New Data Source screen will appear if you select <New Data Source>. You must provide a name for the data source, select “Microsoft Text Driver (*.txt, *.csv)” and click Connect. The ODBC Text Setup screen will then be presented. Uncheck “Use Current Directory” and press the Select Directory button to open the Select Directory screen. Select the drive where the directory containing the data is located, select the folder containing the data, and click OK to close the Select Directory screen. Click OK to close the ODBC Text Setup screen and then click OK to close the Create New Data Source screen. On the Choose Data Source screen, select the newly created data source name if you have created a new data source for comma-separated values data. Select MS Access Database to use Access database files on the CD or select Excel Files to use Excel spreadsheets on the CD. Click OK once you have chosen a data source. If you indicate a database or spreadsheet data source, a Select Database or Select Spreadsheet screen will appear. Select the drive where the database or spreadsheet is located, select the folder containing the database or spreadsheet, select the specific database file or spreadsheet if required, and click OK. The Query Wizard Choose Columns screen will now be displayed. Select the Gaming Business Directory table you wish to use, click the “>” button to select all columns in the table, and click Next. The Query Wizard Filter Data screen is displayed. Select a column to be used to filter the data. For example, select the Responsibilities column within the GamingPropertyContacts table if you wish to select contacts based on departmental responsibility. Next, select an operator such as “Contains” and enter a value such as “Security.” To specify additional criteria for the same column, simply select “and” or “or” depending on whether either or both criteria must be satisfied, and specify the criteria, such as “Contains,” “Security or Surveillance.” Thus you can easily request contacts that have either Security or Surveillance responsibilities. To filter based on another column, select it and specify the desired criteria. Once all criteria are specified, click Next. The Query Wizard Sort Order screen will appear. Specify any desired sort order and click Next. The Query Wizard Finish screen will be displayed. We recommend checking “View data or edit query in Microsoft Query” before pressing the Finish button if you have specified a query involving multiple columns.