[ Home ] [ Mail Merge ] [ Shortcut Keys ] [ Create the Merge Document ]

Setting the Data Source

If the Data source in section 2 of the Mail Merge Helper dialog is not temp.xls!Entire Spreadsheet you must change it to temp.xls!Entire Spreadsheet. To do that, choose Get Data >> Open Data Source in section 2, see Figure B1.

Figure B1: Choosing Get Data >> Open Data Source.
Open data source


The Open Data Source dialog box should appear, see Figure B2. From this dialog box, set the Look in directory to your data directory and change the Files of type to MS Excel Worksheets (*.xls). Finally, select the temp.xls file and click Open.

A small Microsoft Excel dialog box will appear. For Named or cell range, Entire Spreadsheet should be selected. Click OK.

Figure B2: Open Data Source dialog box. Arrows point to important areas of the box.
Open data source


[ Home ] [ Mail Merge ] [ Shortcut Keys ] [ Create the Merge Document ]

Created and maintained by Gary Dalton