Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Writer 3.x Guide
Previous Page Home Next Page

For a data source to be directly accessible from within an OOo document, it must first be registered as described below.

  1. Click File > Wizards > Address Data Source.
  2. Starting the Address Data Source wizard
  3. Select the appropriate type of external address book—in this case, Other external data source. (The choices on this page of the wizard vary with your operating system.) Click Next.
  4. Select type of external address book
  5. On the next page of the Wizard, click Settings.
  6. Starting the Settings part of the Wizard
  7. In the Data Source Properties dialog, select the Database type (in this case, Spreadsheet). Click Next.
  8. Selecting the database type
  9. In the next dialog, click Browse and navigate to the spreadsheet that contains the address information. Select the spreadsheet and click Open to return to this dialog. At this time you may wish to test that the connection has been correctly established by clicking on the Test Connection button (not shown in illustration).
  10. Selecting the spreadsheet document
  11. Click Finish.
  12. In the following dialog, click Next. (Do not click Field Assignment.)
  13. Because this is a spreadsheet, do not click Field Assignment.
  14. Name the file in the Location field. The default is ...\Addresses.odb; but you may replace Addresses with another name if you wish. You may also change the name in the “Address book name” field. In our example, the name “Points” was used for both.
  15. Name the .odb file and the address book.
  16. Click Finish. The data source is now registered.

OpenOffice Writer 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire