1. Field of the Invention
This invention relates to a method, system and computer readable medium for name and address handling (hereinafter called “address handling”), and more particularly to a touch screen, keyboard button, icon, menu, voice command device, etc. (hereinafter called “button”) provided in a computer program, such as word processing program, spreadsheet program, etc., and coupled to an information management source for providing address handling within a document created by the computer program.
2. Background Information
In recent years, with the advent of programs, such as word processors, spreadsheets, etc. (hereinafter called “word processors”) users may require retrieval of information, such as name and address information, etc., for insertion into a document, such a letter, fax, etc., created with the word processor. Typically, the information is retrieved by the user from an information management source external to the word processor, such as a database program, contact management program, etc., or from the word processor itself, for insertion into the document. Examples of such word processors are WORD™, NOTEPAD™, EXCEL™, WORDPAD™, WORDPERFECT™, QUATROPRO™, AMIPRO™, etc., and examples of such information management sources are ACCESS™, OUTLOOK™, ORACLE™, DBASE™, RBASE™, CARDFILE™, etc.
However, the information in the database must constantly be updated by the user. This requires the user to learn how to use and have access to the database. In this case, a change in the information, such as change in address or a name, etc., requires the user of the word processor to implement this change in the database, or alternatively, the change is made to the database centrally by a database administrator.
Accordingly, an object of the present invention is to provide a method, system and computer readable medium for address handling within a computer program.
Another object of the present invention is to provide a method, system and computer readable medium for address handling within a computer program, such as a word processing program, spreadsheet program, etc.
Another object of the present invention is to provide a method, system and computer readable medium for address handling within a computer program, such as a word processing program, spreadsheet program, etc., using an input device provided in the computer program.
Another object of the present invention is to provide a method, system and computer readable medium for address handling within a computer program, such as a word processing program, spreadsheet program, etc., using an input device, such as a touch screen, keyboard button, icon, menu, voice command device, etc., provided in the computer program and coupled to an information management source.
Another object of the present invention is to provide a method, system and computer readable medium for address handling within a computer program, such as a word processing program, spreadsheet program, etc., using an input device such as a touch screen, keyboard button icon, menu, voice command device, etc., provided in the computer program and coupled to an information management source, such as a database program, contact management program, etc.
The above and other objects are achieved according to the present invention by providing a novel method, system and computer readable medium for providing a function item, such as a key, button, icon, or menu, tied to a user operation in a computer, whereby a single click on the function item in a window or program on a computer screen, or one single selection in a menu in a program, initiates retrieval of name and addresses and/or other person or company related information, while the user works simultaneously in another program, e.g., a word processor. The click on the function item initiates a program connected to the button to search a database or file available on or through the computer, containing the person, company or address related data, in order to look up data corresponding to what the user types, or partly typed, e.g., name and/or address in the word processor, the correct data from the database, data related to the typed data, e.g., the name of the person, company, or the traditional or electronic address, or other person, or company, or address related data, and alternatively the persons, companies, or addresses, are displayed and possibly entered into the word processor, if such related data exists.
The present invention also includes a computer readable medium storing program instructions by which the method of the invention can be performed when the stored program instructions are appropriately loaded into a computer, and a system for implementing the method of the invention.
The invention description below refers to the accompanying drawings, of which:
In an embodiment of the present invention, single button addressing is a achieved by providing an input device, such as a touch screen, keyboard, icon, menu, voice command device, etc. (hereinafter called “button”), in a computer program, such as a word processing program, spreadsheet program, etc. (hereinafter called “word processor”), for executing address handling therein.
Accordingly, in a word processor, the button is added and a user types information, such as an addressee's name, or a part of the name, etc. in a document created with the word processor, such as a letter, fax, etc., and then clicks, selects, commands, etc. the button via the appropriate input device, such as a touch screen button, keyboard button, icon, menu choice, voice command device, etc. A program then executes and retrieves the typed information from the document, and searches an information management source, such as a database, file, database program, contact management program, etc. (hereinafter called “database”) to determine if the information, such as the name or part of the name typed and searched by the program exists in the database. If the program does not find stored information, such as a name, corresponding to the name or part of the name typed, the user is asked by the program whether the information, such as the name that was not found, should be added to the database. In addition, the user may enter any other information besides the name, such as addresses, businesses, telephone numbers, fax numbers, e-mail address, etc., so that this other information can be stored in the database for later use.
If the program finds name(s) and address(es) corresponding to the part of the addressee's name typed, this additional information is automatically entered into the user's word processor, optionally with a confirmation from the user that this is the correct data. If the typed address information does not correspond to data already stored in the database, after clicking on the button, the program, for example, lets the user decide: (1) if this is new data (e.g., a new address) for an existing contact; (2) if the stored data should be changed to what the user just typed; (3) if this is a new contact with the same name as the one already entered into the database; or (4) if the typed address is only to be used once, and therefore not to be stored in the database at all. If, later, for example, a name with several address stored in the database is recalled, all addresses for this contact will be displayed, so that the correct address can be selected by the user.
The program may be extended to also store and retrieve other information, such as telephone numbers, fax numbers, e-mail addresses, etc. Once the program recalls the telephone numbers, fax numbers, email addresses, etc., the user can command the program to send e-mails, faxes, etc. Similarly, if the user types in the name of a mailing list, the program create merge letters, group emails, etc.
Referring now to the drawings, wherein like reference numerals designate identical or corresponding parts throughout the several views, and more particularly to
In
If the program find an e-mail address mailing list/category name telephone number or other information, at step 10 an appropriate action is performed by the program and then the program execution quits at step 16. If the program only finds a name or initials, or the like, the program looks up the name in the database at step 12 and at step 18 the program determines what was found. If the program finds more than one possible contact/address match, at step 20 the program displays menu choices to the user to let him choose an appropriate answer. Then at step 22 the program inserts a correct address and name in the document and then at step 16 the program quits execution. If the program finds one match exactly, i.e., one contact with one address, the program inserts the correct address and name in the document at step 22 then quits and then quits execution at step 16. If the program does not find a name in the database, at step 24 the program prompts the user to specify an address and then quits execution at step 16. If the program at step 6 finds a name and an address, at step 14 the name is looked up in the database. Then, at step 26, if no match is found, at step 28 the program inserts an address and a name which are possibly corrected by the user into the database and then quits execution at step 16. If at step 26, the name and address is found, at step 32 the program either takes no action or displays the data for the user to edit. If at step 26, the name is found but not the address, the program prompts the user for a decision at step 30. If the user decides that this is another contact with a same name, the program goes to step 28. If the is user decides that this is a one time occurrence, no action is taken and the program quits at step 16. If the user decides that the contact has, for example, moved and that this is a new address, at step 34 one of the old addresses for the contact is replaced with the new one and the program with the new one and the program quits at step 16. If the user decides that this is an additional address for the contact, at step 36 the additional address is inserted into the database for that contact and execution quits at step 16.
The flowchart shown in
If the program finds a name and address in the database at step 6, then at step 14 the program looks up the name in the database and at step 26 the program determines what it has found. If the program does not find the name at step 26, at step 27 the program prompts the user for a decision and review and whether to insert the contact and address. If the user does not decide to insert the contact address, the program quits at step 16. If the user decides to insert the contact address, at step 28 the program inserts the address and name which may be possibly corrected by the user for program in the database then execution quits at step 16.
If at step 26 the program finds a name and not an address, then at step 29 the name is looked up in the database. Then at step 31 the program decides whether this contact has another address. If the contact does not have another address, at step 33 the program prompts the user for a decision and review and whether to add the address. If the user does not want to add the address at step 33, the program quits at step 16. If the user wants to add the address at step 33 because this is an additional address for the contact, at step 36 the address is inserted in the database for the contact and execution quits at step 16.
At step 30, if the user decides that this is another contact with the same name, then the program goes to step 28. If at step 30 the user decides that this is a one time occurrence, then the program quits at step 16. If at step 30, the user decides that the contact has, for example, moved, the program goes to step 34. If at step 30, the user decides that this is an additional address for the contact, at step 36 the program inserts the address in the database for the contact and then quits at step 16.
Various exemplary screen shots which are generated during execution of the program, according to the present invention, will now be described with reference to
The above example corresponds to steps 2, 4, 6, 12, 18, 22 and 16 in the flow charts of
At this point, the user can cancel the operation by commanding the Cancel button 60, ask the program to store data in the database and return the document by commanding the OK button 56, or check details before storing data into the database by commanding the Details button 58. If the user commands the Details button 58, as shown in, for example,
The above example corresponds to steps 2, 4, 6, 14, 26, 28 and 16 in the flow chart of
The above example corresponds to steps 2, 4, 6, 12, 18, 24, and 16 in the flow of charts of
The above example corresponds to steps 2, 4, 6, 14, 26, 28, 30, 34, 36, and 16 in the flow chart of
At this point, the user may command the Choose button 86 to use the selected address and return to the document, or the user may command the More>>> button 90 to view how the program interpreted what he user typed in the word processor, and possibly change this data, wherein the program generates an updated screen as shown in, for example,
The above example corresponds to steps 2, 4, 6, 12, 18, 20, 22, and 16 in the flow chart of
Alternatively, in the screen shown in
The above example corresponds to steps 2, 4, 6, 12, 14, 26, 28, 30, 34, 36, and 16 in the flow chart of
The above example corresponds to steps 2, 4, 12, 18, 22, and 16 in the flow of charts
As stated above, the system includes at least one computer readable medium or alternatively, the computer readable medium may be accessed through various paths, such as networks, internet, drives, etc. Examples of computer readable media are compact discs, hard disks, floppy disks, tape, magneto-optical disks, PROMs (EPROM, EEPROM, Flash, EPROM), DRAM, SRAM, SDRAM, etc. Stored on any one or on a combination of computer readable media, the present invention includes software for controlling both the hardware of the computer 200 and for enabling the computer 200 to interact with a human user. Such software may include, but is not limited to, device drivers, operating systems and user applications, such as development tools. Such computer readable media further includes the computer program product of the present invention for performing any of the processes according to the present invention, described above (see, e.g.,
The invention may also be implemented by the preparation of application specific integrated circuits or by interconnecting an appropriate network of conventional component circuits, as will be readily apparent to those skilled in the art.
Address handling, according to this invention, is a significant simplification relative to existing methods, and requires little or no training on the part of a user, as correct addresses are retrieved with a minimal number of user commands, “clicks,” keystrokes, etc. In addition, a program according to the present invention, can be programmed and created in most existing programming languages and be connected to most modern word processors. Therefore, according to the present invention, the process of creating and updating records in an address database is significantly simplified, since this may now be performed directly from the word processor.
Although the present invention is defined in terms of word processing documents, such as WORD™ documents and EXCEL™ spreadsheets, the present invention is applicable to all types of word processing documents such as NOTEPAD™, WORDPAD™, WORDPERFECT™, QUATROPRO™, AMIPRO™, etc., as will be readily apparent to those skilled in the art.
Although the present invention is defined in terms of information management or is database programs, such as OUTLOOK™, etc., the present invention is applicable to all types of information management or database programs such as ACCESS™, ORACLE™, DBASE™, RBASE™, CARDFILE™, including “flat files,” etc., as will be readily apparent to those skilled in the art.
Although the present invention is defined in terms of providing an input device, such as a button 42 in a word processor for address handling therein, the present invention may be practiced with all types of input devices, such as touch screen, keyboard button, icon, menu, voice command device, etc., as will be readily apparent to those skilled in the art.
Although the present invention is defined in terms of a program retrieving information from a document before searching a database, the user may select the information in the document to be searched by the program in the database (e.g., by highlighting, selecting, italicizing, underlining, etc.), as will be readily apparent to those skilled in the art.
Although the present invention is defined in terms of a program retrieving a name or portion thereof from a document before searching a database the program may retrieve an address or portion thereof from the document before searching the database and insert, correct, complete, etc., the retrieved address based on the information found in the database corresponding to the retrieved address or portion thereof, as will be readily apparent to those skilled in the art.
Obviously, numerous modifications and variations of the present invention are possible in light of the above teachings. It is therefore to be understood that within the scope of appended claims, the invention may be practiced otherwise than as specifically described herein.
This application claims priority and contains subject matter related to Norwegian patent application No. 984066 filed on Sep. 3, 1998, the entire contents of which are hereby incorporated by reference.
The present application is a continuation of commonly assigned copending U.S. patent application Ser. No. 09/189,626, which was filed on Nov. 10, 1998 now U.S. Pat. No. 6,323,853, by Hedloy for a METHOD, SYSTEM and COMPUTER READABLE MEDIUM FOR ADDRESSING HANDLING FROM A COMPUTER PROGRAM and is hereby incorporated by reference.
Number | Name | Date | Kind |
---|---|---|---|
4674065 | Lange et al. | Jun 1987 | A |
5226117 | Miklos | Jul 1993 | A |
5267155 | Buchanan et al. | Nov 1993 | A |
5331555 | Hashimoto et al. | Jul 1994 | A |
5375200 | Dugan et al. | Dec 1994 | A |
5392386 | Chalas | Feb 1995 | A |
5416901 | Torres | May 1995 | A |
5491783 | Douglas et al. | Feb 1996 | A |
5491784 | Douglas et al. | Feb 1996 | A |
5500859 | Sharma et al. | Mar 1996 | A |
5530853 | Schell et al. | Jun 1996 | A |
5546447 | Skarbo et al. | Aug 1996 | A |
5576955 | Newbold et al. | Nov 1996 | A |
5606712 | Hidaka | Feb 1997 | A |
5640565 | Dickinson | Jun 1997 | A |
5666502 | Capps | Sep 1997 | A |
5708804 | Goodwin et al. | Jan 1998 | A |
5724597 | Cuthbertson et al. | Mar 1998 | A |
5732229 | Dickinson | Mar 1998 | A |
5761656 | Ben-Shachar | Jun 1998 | A |
5781189 | Holleran et al. | Jul 1998 | A |
5793972 | Shane | Aug 1998 | A |
5794228 | French et al. | Aug 1998 | A |
5794259 | Kikinis | Aug 1998 | A |
5799302 | Johnson et al. | Aug 1998 | A |
5805886 | Skarbo et al. | Sep 1998 | A |
5815830 | Anthony | Sep 1998 | A |
5826257 | Snelling, Jr. | Oct 1998 | A |
5835089 | Skarbo et al. | Nov 1998 | A |
5859636 | Pandit | Jan 1999 | A |
5864848 | Horvitz et al. | Jan 1999 | A |
5873107 | Borovoy et al. | Feb 1999 | A |
5884309 | Vanechanos, Jr. | Mar 1999 | A |
5893093 | Wills | Apr 1999 | A |
5896533 | Ramos et al. | Apr 1999 | A |
5907838 | Miyasaka et al. | May 1999 | A |
5913214 | Madnick et al. | Jun 1999 | A |
5924090 | Krellenstein | Jul 1999 | A |
5926808 | Evans et al. | Jul 1999 | A |
5930471 | Milewski et al. | Jul 1999 | A |
5946647 | Miller et al. | Aug 1999 | A |
5999938 | Bliss et al. | Dec 1999 | A |
6006218 | Breese et al. | Dec 1999 | A |
6021403 | Horvitx et al. | Feb 2000 | A |
6026398 | Brown et al. | Feb 2000 | A |
6067565 | Horvitz | May 2000 | A |
6085201 | Tso | Jul 2000 | A |
6085226 | Horvitz | Jul 2000 | A |
6182133 | Horvitz | Jan 2001 | B1 |
6223570 | Horvitz et al. | May 2001 | B1 |
6260035 | Horvitz et al. | Jul 2001 | B1 |
6262730 | Horvitz et al. | Jul 2001 | B1 |
6323853 | Hedloy | Nov 2001 | B1 |
Number | Date | Country |
---|---|---|
0 093 250 | Sep 1983 | EP |
0093250 | Nov 1983 | EP |
Number | Date | Country | |
---|---|---|---|
20020054092 A1 | May 2002 | US |
Number | Date | Country | |
---|---|---|---|
Parent | 09189626 | Nov 1998 | US |
Child | 09923134 | US |