JP2004094740A - E-mail distribution system and its method and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an easy-to-establish e-mail distribution system allowing accurate and easy indication of an area for a distribution destination and requiring less burden on customers. <P>SOLUTION: The e-mail distribution system comprises a searching screen part 25 for searching necessary data from a integrated database on request from a user and displaying a searching screen which indicates an area for narrowing down the customers using a map corresponding to the request, a mapping part 26 for allowing the user to search coordinate data contained in the area narrowing down the customers from the integrated database using the map displayed on the searching screen, a customer data searching part 27 for acquiring necessary data for e-mail distribution out of data for the customers in accordance with the coordinate data searched by the mapping part 26, and a e-mail distributing part 28 for distributing a text input by the user in accordance with the data searched by the customer data searching part. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a mail delivery system, a mail delivery method, and a mail delivery program that can narrow down customers and deliver mail when delivering mail to customers.
[0002]
[Prior art]
2. Description of the Related Art Conventionally, in order to announce advertisement information, product information, and the like to consumers, sending direct mail or sending e-mail has been widely performed. In this case, send the e-mail to people who are not interested in it and delete it even if you send direct mail. That is being done. For example, in order to narrow down the target, the consumer is required to register a genre for which information is desired, a product of interest, an address, a telephone number, an e-mail address, a contact, etc., and a transmission destination list and a database are created. , People who are interested in the product or genre they want to announce are searched from the database. In addition, if it is desired to distribute to the vicinity of a specific store, narrowing down is performed by inputting an address or a zip code in the vicinity based on the address of the store.
[0003]
Japanese Patent Application Laid-Open No. 2000-298690 discloses that, for each user, location information related to the user or location information of a place explicitly searched for by the user is collected, and a home range attribute database for each user is collected. There is disclosed a customer list creation system that creates and creates a prospective customer list using the home range attribute database.
[0004]
[Patent Document 1]
JP 2000-298690 A
[0005]
[Problems to be solved by the invention]
However, in the method of narrowing down using an address or a zip code, the area can be roughly specified. For example, when e-mail is to be distributed to a person who lives near a specific store or facility, It is impossible to indicate a narrow area. In addition, when specifying an address or a person who has a work place along a private railway line, it is necessary to check and enter the address near the railway line, which takes time and effort, and it is not easy to specify the vicinity of the railway line accurately. Absent.
[0006]
Further, in the system of the above-mentioned document, it takes a long time to accumulate the data of the home range attribute of the user, and the system of this document cannot be used unless the home range attribute database is created. There is a problem. Further, in the system described in the above-mentioned document, since the user is required to input the activity range information, the user is burdened.
[0007]
The present invention has been made based on the above circumstances, and it is possible to accurately and easily specify an area of a distribution destination, and furthermore, a mail distribution system, a mail distribution method, and a mail distribution method which are less burdensome to a customer and easy to realize. The purpose is to provide a mail distribution program.
[0008]
[Means for Solving the Problems]
In order to achieve the above object, a mail delivery system according to the present invention comprises: an integrated database having map data including coordinate data; and data relating to a customer including coordinate data of latitude and longitude corresponding to the address of the customer; Geocoding means for converting the number data into the corresponding latitude / longitude coordinate data and outputting the data; and when data relating to the customer is newly registered or changed, the address or zip code data of the customer is sent to the geocoding means. A means for managing the integrated database, such as acquiring the coordinate data and updating the contents of the integrated database based on the coordinate data, and a request from the integrated database based on a request from a user. To search for specific data and specify the area to narrow down customers using the map corresponding to the request Search screen display means for displaying a search screen, area designating means for designating an area for narrowing down customers using a map displayed on the search screen, and the designated area using the integrated database Searching means for searching for the coordinate data contained in the data and obtaining data necessary for mail distribution among data relating to the customer based on the coordinate data; and a user input based on the data searched by the searching means. Mail distribution means for distributing the sentence described above.
[0009]
Further, in the mail distribution method according to the present invention, the customer data of the integrated database having the map data including the coordinate data and the customer data including the coordinate data of the latitude and longitude corresponding to the customer address is newly registered or changed. Then, a management step of managing the integrated database, such as converting the address or postal code data of the customer into corresponding latitude / longitude coordinate data and updating the contents of the integrated database based on the converted coordinate data. A search screen displaying step for searching necessary data from the integrated database based on a request from a user and displaying a search screen for indicating an area for narrowing down customers using a map corresponding to the request And an area instruction for designating an area for narrowing down customers using the map displayed on the search screen. A search step for searching the coordinate data included in the designated area using the integrated database, and acquiring data necessary for mail distribution among data relating to the customer based on the coordinate data, A mail delivery step of delivering a text input by the user based on the data searched by the search step.
[0010]
In addition, the mail distribution program according to the present invention provides a computer for distributing a mail with an integrated database having map data including coordinate data and data on a customer including coordinate data of latitude and longitude corresponding to the address of the customer. Data recording means for recording, geocoding means for converting the address or postal code data into the corresponding latitude / longitude coordinate data and outputting the data, and when data relating to the customer is newly registered or changed, the address or postal code of the customer is Management means for transmitting data to the geocoding means, acquiring the coordinate data, and managing the integrated database, such as updating the contents of the integrated database based on the coordinate data, based on a request from a user; And retrieves necessary data from the integrated database and generates a map corresponding to the request. Screen display means for displaying a search screen for designating an area for narrowing down customers, area designating means for designating an area for narrowing down customers using a map displayed on the search screen, and the integrated database Search means for searching the coordinate data included in the designated area by using the search data, and search means for obtaining data necessary for mail distribution among data relating to the customer based on the coordinate data, and the search means searches for the data. This is to make it function as mail distribution means for distributing the text input by the user based on the data.
[0011]
BEST MODE FOR CARRYING OUT THE INVENTION
[Configuration of Embodiment] An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a schematic configuration diagram of a mail distribution system according to one embodiment of the present invention. As shown in FIG. 1, the mail delivery system according to the present embodiment includes a system server 11 that is connected to a network and narrows down mail delivery destination customers based on an instruction from a user, and delivers mail to the narrowed down customers. A plurality of operation terminals 12 for narrowing down the customers to whom the user sends mails, and data of addresses or postal codes (hereinafter, also simply referred to as addresses, etc.) are converted into corresponding latitude / longitude coordinate data and output. The apparatus includes a geocoding server 13, a map database 14 having map data, customer ID data, and coordinate data corresponding to the ID, and a customer database 15 having customer data including customer ID data.
[0012]
FIG. 2 is a schematic functional block diagram of the system server 11. As shown in FIG. 2, the system server 11 of the present embodiment includes a control unit 21 that controls the entire system server, and a transmission / reception unit 22 that transmits and receives data to and from the terminal 12 and the geocoding server 13 via a network. A map database management unit 23 for managing addition, change, and deletion of data in the map database 14; a customer database management unit 24 for managing addition, change, and deletion of the customer database 15; A search screen display unit 25 for displaying a search screen including a map for specifying an area for narrowing down customers on the screen of the terminal 12 based on a request from the terminal 12, and coordinate data included in the specified area And a mapping unit 26 for searching the map data from the map database. Using the ID data, a customer database search unit 27 for searching the customer database 15 for data such as a name and an e-mail address necessary for sending an e-mail, and using the e-mail address and the like searched by the customer database search unit 27 And a mail distribution unit 28 for distributing the text created by the user. The search means of the present invention includes a mapping unit 26 and a customer database search unit 27. The management means of the present invention includes a map database management unit 23 and a customer database management unit 24.
[0013]
The terminal 12 includes a display unit 121 that displays a search screen and the like sent from the system server 11, and a mouse (an area indicating unit that indicates a specific area on a map displayed on the screen by the display unit). (Not shown), and a keyboard (not shown) as input means for inputting text to be distributed. A commercially available personal computer can be used as the terminal.
[0014]
FIG. 3 is a diagram for explaining a customer database. As shown in FIG. 3, the customer database 15 stores, as shown in FIG. 3, an ID number assigned to identify a customer, which is data necessary for delivering an e-mail, a customer address, and a customer mail address (E-mail). Email address) and customer name data. It should be noted that the customer database 15 also stores data such as the workplace name, workplace address, gender, date of birth, etc., in addition to those described in FIG. The registration in the customer database may be such that the customer himself / herself can access and register a management server (not shown) that separately manages the customer database 15 using his / her personal computer. The address, name, and the like written on paper may be read by OCR and registered in the customer database. Further, as the customer database 15, an existing database can be used.
[0015]
FIG. 4 is a diagram for explaining the map database. As shown in FIG. 4, the map database 14 stores, in addition to the map data, a customer ID number and coordinate data indicating the customer's address in latitude and longitude. Although FIG. 4 shows only the coordinate data of the customer ID number and the address of the customer, the map database also stores the coordinate data of the work address in addition to these. The customer ID number in the map database 14 and the customer ID number in the customer database 15 are the same. As the map data, a commercially available map having data of the map body and coordinate data can be used. The customer ID data and the corresponding coordinate data shown in FIG. 4 are newly created in this embodiment as tabular data.
[0016]
FIG. 5 is a schematic diagram of a search screen displayed on the terminal. The search screen display unit 25 displays the search screen shown in FIG. 5 on the terminal 12 based on an instruction from the control unit 11. As shown in FIG. 5, a horizontal scroll bar 31 for scrolling the screen left and right, a vertical scroll bar 32 for scrolling the screen up and down, and various buttons 33 are arranged on the search screen. Have been. The button 33 includes a free curve button and a polygonal line button used when the user designates an area, a completion button which is clicked when performing a search after the designation of the area, a button for changing the scale, and the like. Have been.
[0017]
The geocoding server 13 converts the address and the like transmitted from the customer database management unit 24 of the system server 11 and, if necessary, the data of the work place into coordinate data composed of latitude and longitude on a map, and sends the data to the system server 11. Send. The geocoding software used by the geocoding server 13 can use commercially available software. The customer database management unit 24 manages the customer database 15, sends data such as the address of the new customer to the geocoding server 13 when a new customer is registered, and acquires coordinate data corresponding to the new address and the like. , And sends the customer ID data corresponding to the acquired coordinate data to the map database management unit 23. The map database management unit 23 updates the map database 13 based on the received new customer ID and coordinate data. Further, when the customer's address or the like is changed, the customer database management unit 24 sends data of the changed address or the like to the geocoding server 13 to obtain coordinate data corresponding to the changed address or the like, and obtains the coordinate data. The data of the changed customer ID corresponding to the changed coordinate data is sent to the map database management unit 23. The map database management unit 23 updates the map database 13 based on the sent customer ID and coordinate data. When the customer data is deleted, the deleted customer data is deleted from the map database 13 in the same manner. When using the existing customer database, the customer address and the like are collectively sent to the geocoding server 13 in advance, the corresponding coordinate data is acquired, and the acquired coordinate data and the corresponding customer ID are entered. The data is sent to the map database management unit, and the customer ID and the corresponding coordinate data are stored in the map database 14 as data in a table format.
[0018]
[Processing Procedure of Embodiment] Next, a processing procedure of the mail distribution system of the present embodiment will be described with reference to FIG. FIG. 6 is a diagram for explaining the processing procedure of the mail distribution system of the present embodiment. Hereinafter, a case where the mail distribution system of the present embodiment is installed in a real estate company will be described. In addition, the following processing procedure is used to promote sales of new condominiums built near Shinjuku Station by a salesperson who is a user working at a branch office. This is a procedure for sending a guidance message to a person who has an office.
[0019]
(1) First, when the user accesses the system server at the head office from the terminal 12 at the branch office 11, an input screen for the user's ID and password is displayed on the terminal. The user inputs his / her ID and password, and clicks an OK button. As a result, the terminal 12 transfers the entered user ID and password to the head office system server 11.
[0020]
(2) When the transferred ID and password are registered and correct, the control unit 21 of the system server 11 sends an instruction to the search screen display unit 25, and sends the search screen shown in FIG. Is displayed. For the map to be displayed first on the search screen, before sending the search screen, a screen for selecting the area to be displayed is displayed on the terminal, and on that screen, the prefecture name, municipal name, etc. are sequentially selected. You may be asked to do so.
[0021]
(3) The user moves the cursor on the search screen using the mouse, and indicates the area of the customer who wants to send the mail on the map displayed on the screen using a graphic such as a closed curve. FIG. 5 shows a state in which the user has selected a free curve and instructed the vicinity of each JR or private railway line passing through Shinjuku by the selected free curve. The figure used to designate this area is not limited to a figure designated by a free curve, and if it is a closed figure, it may be a figure such as a circle, a rectangle, an ellipse, or a polygonal line. Is also good. It is also possible to designate a plurality of areas. When the instructions for the area for narrowing down customers are completed, click the completion button on the screen. As a result, the terminal 12 transfers the data in the designated area to the system server 11.
[0022]
(4) When receiving the data of the area for narrowing down the customers from the terminal, the control unit 21 of the system server 11 sends a search instruction to the mapping unit 26. Upon receiving this instruction, the mapping unit 26 accesses the map database, and searches for coordinate data included in the transmitted area.
[0023]
(5) The mapping unit 26 acquires, as a search result, coordinate data included in the area and a customer ID of the coordinate data. (6) The control unit 21 transfers only numerical values indicating the total number of the acquired data to the terminal 12 as result data. The terminal 12 displays the total value, an OK button, and a cancel button. The user clicks the OK button when judging that this value is sufficient. On the other hand, if it is determined that the total number is too large, or if the total number is too small, the cancel button is clicked. When the cancel button is clicked, the control unit 21 displays the search screen again on the terminal screen. The user designates the area again according to the procedure described above, and clicks the completion button.
[0024]
(7) When the user makes a good judgment on the number of cases displayed on the screen and clicks the OK button, the terminal 12 transfers a signal to that effect to the system server 11 and requests a narrowed list of customers. (8) The control unit 21 instructs the customer database search unit 27 to create a narrowed down customer list. The customer database search unit 27 searches the customer database 15 using the customer ID corresponding to each piece of coordinate data searched by the mapping unit 26.
[0025]
(9) As a search result, data such as a name, a workplace name, and an e-mail address necessary for mail distribution are acquired for a customer having an address or a work place in the area.
(10) Based on the acquired data, a list including the narrowed down customer names and e-mail addresses is created and displayed on the terminal. The user checks the list displayed on the terminal screen, and clicks the OK button if the list is good. If the list is not what you want, click the Cancel button and start over with the area instructions again.
[0026]
(11) If the user decides that this list is sufficient and clicks the OK button on the screen of the terminal 12, a screen for inputting a sentence to be sent by e-mail is displayed on the screen of the terminal. Since the screen for inputting the text is publicly known, a detailed description of this screen will be omitted. The user uses this input screen to input a sentence to be transferred. When the input operation is completed, click the end button on the screen. Thereby, the input text is transferred to the system server 11. Upon receiving the text, the control unit 21 instructs the mail distribution unit 28 to distribute the text. The mail distribution unit 28 refers to the narrowed down list of customers and distributes the sentence to the narrowed down customer by e-mail.
[0027]
(12) When a user enters his / her ID and password again from the terminal 12 to access the system server after an elapse of an appropriate time according to the number of customers narrowed down, distribution to the customers has been completed. Then, a message indicating the end of distribution is displayed on the screen of the terminal 12, and if not, a message being distributed is displayed on the screen. Through the above procedure, among the many customers, search for the area you want to distribute, that is, the customers who have an address or work place near the JR or private railway line at Shinjuku Station, and e-mail the guidance text of the new apartment. Can be delivered at
[0028]
[Effects of the Embodiment] According to the mail distribution system of the present embodiment described above, it is only necessary to use the cursor to specify the JR and private railway lines that are approaching Shinjuku Station on the map displayed on the search screen. It is possible to accurately designate a customer who has an address or a work place along these lines from among a large number of customers, and distribute the guidance message.
[0029]
Further, according to the present embodiment, it is also possible to easily specify a customer who has an address or a work place within an extremely narrow range, for example, within a radius of 100 m of Shinjuku Station, and distribute the guidance text.
[0030]
Further, according to this embodiment, a customer who wishes to send a real estate guide accesses a management server or the like that manages a customer database via the Internet, for example, and first writes his / her own address or name to the customer database. You only need to register, so there is no heavy burden on your customers. Further, the customer database is a known one, and can be easily constructed, or an existing one can be used. When using an existing customer database, it is possible to generate coordinate data from addresses and the like in a batch by a geocoding server in advance and easily create tabular data including a customer ID and corresponding coordinate data in a map database. it can. Further, when a new customer is registered in the customer database, coordinate data is automatically generated by the geocoding server, and the coordinate data corresponding to the new customer ID is automatically added to the map database. Therefore, the map database of the present embodiment can also be easily constructed. That is, the system of the present embodiment is easier to realize than the conventional system.
[0031]
[Other Embodiments] The present invention is not limited to the above embodiment, and various modifications are possible within the scope of the gist. For example, in the above-described embodiment, the case where the customer database and the map database are provided has been described. However, both may be integrally configured and integrated into one database as an integrated database.
[0032]
Further, in the above-described embodiment, a case has been described where a salesperson who is an employee of a real estate company uses the present system. However, when an unspecified person uses the mail distribution system of the present embodiment, a customer Since it is not preferable to disclose personal information to others, sending the list after narrowing down the area may be omitted, and only the number of cases in the area may be displayed on the user's terminal.
[0033]
Further, in the above-described embodiment, the case where the server and the terminal are connected via the network has been described. However, the mail delivery system according to the present invention can be configured by one computer without using the network. is there.
[0034]
Further, in the above-described embodiment, the case where the system server and the geocoding server are provided has been described. However, the system server and the geocoding server may be combined into one server. Conversely, in the present embodiment described above, a case has been described where the system server performs mail distribution. However, for mail distribution, a dedicated mail distribution server may be separately provided. Providing such a dedicated server enables high-speed processing.
[0035]
Further, an object of the present invention is to supply a program code (including an execution format) of software for realizing the functions of the system of the above-described embodiment to a system or an apparatus by using a storage medium in which the whole or a part thereof is recorded. Needless to say, the present invention can also be achieved by a computer (or CPU, MPU) of the system or apparatus reading out the program code stored in the storage medium and executing all or a part of the operation.
[0036]
In this case, the program code itself read from the storage medium implements the functions of the present embodiment, and the storage medium storing the program code constitutes the present invention.
[0037]
As a storage medium for supplying the program code, a ROM, a flexible disk, a hard disk, an optical disk, a magneto-optical disk, a CD-ROM, a CD-R, a DVD, a magnetic tape, a nonvolatile memory card, and the like can be used. Further, the program code may be supplied by downloading via a communication line, or the program may be supplied and executed using a technique such as JAVA (registered trademark).
[0038]
The functions of the present embodiment are not only realized by the computer executing the readout program code, but also the OS or the like running on the computer performs the actual processing based on the instruction of the program code. It goes without saying that a case where some or all of the functions are performed and the functions of the present embodiment are realized by the processing is also included.
[0039]
Further, after the program code read from the storage medium is written to a memory provided in an extended function board inserted into the computer or an extended function unit connected to the computer, the function expansion is performed based on the instruction of the program code. It goes without saying that a CPU or the like provided in the board or the function expansion unit performs part or all of the actual processing, and the processing realizes the functions of the present embodiment.
[0040]
In addition, the present invention may be a program product including a program for causing a computer to realize the functions of the system of the above embodiment. Here, the program product includes not only a computer program but also a recording medium on which the program is recorded or a computer.
[0041]
【The invention's effect】
As described above, according to the present invention, the area for narrowing down the customers to whom mail is to be delivered is specified on the map displayed on the search screen, so that the delivery destination area can be specified accurately and easily. In addition, since the customer only has to input the name and the e-mail address, etc., the burden on the customer is small. Further, the coordinate data included in the designated area is searched, and the mail having the coordinate data is sent to the customer having the coordinate data. Since distribution is performed, it is possible to provide a mail distribution system, a mail distribution method, and a mail distribution program that are easy to realize.
[Brief description of the drawings]
FIG. 1 is a schematic configuration diagram of a mail distribution system according to an embodiment of the present invention.
FIG. 2 is a schematic functional block diagram of a system server.
FIG. 3 is a diagram for explaining a customer database.
FIG. 4 is a diagram for explaining a map database.
FIG. 5 is a schematic diagram of a search screen displayed on the terminal.
FIG. 6 is a diagram illustrating a processing procedure of the mail distribution system according to the embodiment.
[Explanation of symbols]
11: System server, 12: Operation terminal, 13: Geocoding server, 14: Map database, 15: Customer database, 21: Control unit, 22: Transmission / reception unit, 23: Map database management unit, 24: Customer database management unit, 25: search screen display section, 26: mapping section, 27: customer data search section, 28: mail delivery section

Claims (7)

An integrated database having map data including coordinate data, and data regarding the customer including coordinate data of latitude and longitude corresponding to the address of the customer;
Geocoding means for converting address or postal code data into corresponding latitude / longitude coordinate data and outputting the data;
When data relating to the customer is newly registered or changed, the data of the customer's address or postal code is sent to the geocoding means, the coordinate data is acquired, and the contents of the integrated database are updated based on the coordinate data. Management means for managing the integrated database, such as
Search screen display means for searching a necessary data from the integrated database based on a request from a user and displaying a search screen for indicating an area for narrowing down customers using a map corresponding to the request,
Using a map displayed on the search screen, area instructing means for instructing an area for narrowing down customers,
Search means for searching for the coordinate data included in the designated area using the integrated database, and acquiring data necessary for mail distribution among data relating to the customer based on the coordinate data,
Mail delivery means for delivering a sentence entered by a user based on the data searched by the search means;
A mail delivery system comprising: A mail delivery system in which a plurality of terminals and a system server are connected via a network using a telephone line or the like,
An integrated database having map data including coordinate data and data relating to the customer including coordinate data of latitude and longitude corresponding to the address of the customer; and
The system server comprises:
Geocoding means for converting address or postal code data into corresponding latitude / longitude coordinate data and outputting the data;
When data relating to the customer is input or changed, the data of the customer's address or postal code is sent to the geocoding means, coordinate data is acquired, and the contents of the integrated database are updated based on the coordinate data. Management means for managing the integrated database of
Based on a request from the terminal, a search screen for searching required data from the integrated database and displaying a search screen for indicating an area for narrowing down customers using a map corresponding to the request is displayed on the screen of the terminal. Screen display means;
When the terminal instructs and transmits an area for narrowing down customers, the coordinate database contained in the designated area is searched using the integrated database, and among the data relating to the customer based on the coordinate data, Search means for acquiring data necessary for mail delivery,
Mail delivery means for delivering a sentence from the terminal based on the data searched by the search means,
The terminal is
Display means for displaying a search screen or the like sent from the system server;
Instructing means for instructing an area for narrowing down customers on a map of a search screen displayed by the display means,
An input means for inputting a sentence to be delivered; When the terminal has transmitted an area for narrowing down customers, the system server transmits to the terminal the number of pieces of coordinate data included in the area to the terminal, and a distribution instruction from the terminal is issued. 3. The mail transmission system according to claim 2, wherein the sentence is delivered by the mail delivery means when there is a message. A customer database having data on customers including customer ID data;
4. The mail distribution system according to claim 2, wherein the mail distribution system is divided into map data including coordinate data, and a map database having data of the customer ID and coordinate data of the customer corresponding to the customer ID. In place of the geocoding means, a geocoding server connected to the network for converting address or postal code data into corresponding latitude / longitude coordinate data and outputting the data is provided, wherein 3. The mail delivery system according to 3 or 4. When data relating to a customer in the integrated database having map data including coordinate data and data relating to the customer including coordinate data of the latitude and longitude corresponding to the address of the customer is newly registered or changed, the address or zip code of the customer is changed. A management step of converting the data into corresponding latitude / longitude coordinate data, and managing the integrated database, such as updating the contents of the integrated database based on the converted coordinate data;
Based on a request from a user, a search screen displaying step of searching for necessary data from the integrated database and displaying a search screen for indicating an area for narrowing down customers using a map corresponding to the request,
Using a map displayed on the search screen, an area instruction step of instructing an area for narrowing down customers,
A search step of searching for the coordinate data included in the designated area using the integrated database, and acquiring data necessary for mail distribution among data relating to the customer based on the coordinate data,
A mail delivery step of delivering a sentence entered by a user based on the data searched by the search step;
A mail delivery method, comprising: A computer for delivering mail,
Data recording means for recording an integrated database having map data including coordinate data and data relating to the customer including coordinate data of latitude and longitude corresponding to the address of the customer;
Geocoding means for converting address or postal code data into corresponding latitude / longitude coordinate data and outputting the data;
When data relating to the customer is newly registered or changed, the data of the customer's address or postal code is sent to the geocoding means, the coordinate data is acquired, and the contents of the integrated database are updated based on the coordinate data. Management means for managing the integrated database, such as
Search screen display means for searching a required data from the integrated database based on a request from a user and displaying a search screen for indicating an area for narrowing down customers using a map corresponding to the request,
Using a map displayed on the search screen, an area instructing unit for instructing an area for narrowing down customers;
A search unit that searches the coordinate data included in the designated area using the integrated database, and obtains data necessary for mail distribution among data regarding the customer based on the coordinate data,
A mail distribution program for functioning as a mail distribution unit that distributes a text input by a user based on data retrieved by the retrieval unit.

Images