Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Wordperfect/Access 97 Merge
- Thread starter SkipC
- Start date
The only way to do it is to export your data to an excell spreadsheet, a dbase database, or a tab deliniated text file. Unfortunately, Corel doesn't recognize MS programs like access. It works real well with dBase but for some reason they never wrote it to go with access.
I've done this a few times and it seems to work well if you export it to an excel file then when you go to your merge document you can use insert spreadsheet/database and tell it to import it into a mail merge file.
I've done this a few times and it seems to work well if you export it to an excel file then when you go to your merge document you can use insert spreadsheet/database and tell it to import it into a mail merge file.
You can use an Access 97 database with WordPerfect 8 and the merge feature. It works really well.
In WordPerfect, click on tools, merge from the pull-down menu. The merge dialog box will appear. Select create document. This will allow you to create the form file that will be filled in by your Access 97 database. A dialog box will come up that will allow you to associate your form file with a data file, in this case a table in your Access 97 database. Click on Associate an ODBC Data Source, then click the Select ODBC Data Source button. You should be taken to the Select ODBC Data Source dialog box. You may receive an error message going into it. Click OK to go past the error. Select MS Access 97 Database from the drop down box. You will be taken to a Select Database dialog box. Change to the directory where your Access 97 database resides and highlight your database and click the OK button. You will be taken back to the Select ODBC Data Source dialog box. At this point you will be able to select the table that you want to pull information from from the Table drop down list. Highlight the table that you wish to pull data from and click OK. You will be taken back to the Associate Form and Data File dialog box. Click OK. You will be taken to a WordPerfect document screen where you will have the Merge toolbar available. Create your file and click on the Insert Field button where you want to insert a field. The Select Data Base dialog box will appear. Highlight the database that you want to select information from and click OK. At that point, you will see the Insert Field Name or Number dialog box. In it, you will see the fields that are available in the table that you selected for your data. Highlight the field that you want to insert and choose the appropriate insert option from the dialog box (you may want to keep the dialog box open until you have inserted all of the fields that you want in your document). After you have closed the Insert Field Name or Number dialog box, you can merge your form file with the data from the database by clicking on the Merge button from the toolbar. You will see the Perform Merge dialog box. This box will give you options of how the merge will be performed such as where the output will go, etc. Click the Merge button to begin the merge. You may be prompted to select the database again for each field that you have inserted into your form file. Go ahead and select the appropriate database file. When it is finished merging, you will have a new document with all of the information that you wanted!
In WordPerfect, click on tools, merge from the pull-down menu. The merge dialog box will appear. Select create document. This will allow you to create the form file that will be filled in by your Access 97 database. A dialog box will come up that will allow you to associate your form file with a data file, in this case a table in your Access 97 database. Click on Associate an ODBC Data Source, then click the Select ODBC Data Source button. You should be taken to the Select ODBC Data Source dialog box. You may receive an error message going into it. Click OK to go past the error. Select MS Access 97 Database from the drop down box. You will be taken to a Select Database dialog box. Change to the directory where your Access 97 database resides and highlight your database and click the OK button. You will be taken back to the Select ODBC Data Source dialog box. At this point you will be able to select the table that you want to pull information from from the Table drop down list. Highlight the table that you wish to pull data from and click OK. You will be taken back to the Associate Form and Data File dialog box. Click OK. You will be taken to a WordPerfect document screen where you will have the Merge toolbar available. Create your file and click on the Insert Field button where you want to insert a field. The Select Data Base dialog box will appear. Highlight the database that you want to select information from and click OK. At that point, you will see the Insert Field Name or Number dialog box. In it, you will see the fields that are available in the table that you selected for your data. Highlight the field that you want to insert and choose the appropriate insert option from the dialog box (you may want to keep the dialog box open until you have inserted all of the fields that you want in your document). After you have closed the Insert Field Name or Number dialog box, you can merge your form file with the data from the database by clicking on the Merge button from the toolbar. You will see the Perform Merge dialog box. This box will give you options of how the merge will be performed such as where the output will go, etc. Click the Merge button to begin the merge. You may be prompted to select the database again for each field that you have inserted into your form file. Go ahead and select the appropriate database file. When it is finished merging, you will have a new document with all of the information that you wanted!
- Status
Similar threads
- Locked
- Question