JP6231846B2 - Transmission target output device, transmission target output method, and program - Google Patents

Description

  The present invention relates to an apparatus or the like for outputting information to be transmitted.

  As a conventional technique, a form generation apparatus capable of outputting a form file by attaching it to an e-mail has been known (for example, see Patent Document 1).

Japanese Patent Laying-Open No. 2006-184961 (first page, FIG. 1 etc.)

  However, in the related art, when transmitting information to be transmitted by e-mail, there is a problem that it is not possible to easily create an e-mail having appropriate contents according to the transmission object.

  For example, if the application software that sends the e-mail creates e-mail information with the form file specified by the user attached, the e-mail with the appropriate information corresponding to each attached file is placed. I couldn't make it.

  The present invention has been made to solve such a problem, and when transmitting information to be transmitted by e-mail, it is possible to easily create an e-mail having appropriate contents according to the transmission object. An object is to provide a target output device.

  The transmission target output device of the present invention is specified by a transmission target storage unit in which one or more transmission target information that is transmission target information is stored, target specification information that is information for specifying transmission target information, and target specification information Target mail information storage unit that stores one or more target mail information having text related information that is information related to the text of a mail for transmitting the transmission target information, and an instruction to transmit the one or more transmission target information A transmission instruction receiving unit that receives the transmission instruction, a body information acquisition unit that acquires the body related information associated with the target identification information that identifies the transmission target information indicated by the transmission instruction, using the target mail information, and transmission The transmission target output device includes one or more transmission target information indicated by the instruction and an output unit that outputs the text related information acquired by the text information acquisition unit.

  With this configuration, when transmitting information to be transmitted by e-mail, it is possible to easily create an e-mail having an appropriate content according to the transmission target.

  In the transmission target output device of the present invention, in the transmission target output device, the target mail information further includes transmission destination information that is information indicating a transmission destination of the mail, and the text information acquisition unit further includes: The destination information associated with the target identification information for specifying the transmission target information indicated by the transmission instruction is acquired using the target mail information, and the output unit further outputs the destination information acquired by the text information acquisition unit The transmission target output device.

  With such a configuration, it is possible to easily create an e-mail specifying a transmission destination according to transmission target information.

  In the transmission target output device according to the present invention, in the transmission target output device, the text information acquisition unit transmits the transmission target information to the text related information associated with the target specifying information for specifying the transmission target information indicated by the transmission instruction. This is a transmission target output device that acquires text related information to which information acquired from is added.

  With such a configuration, it is possible to create a mail to which information of transmission target information is added. For example, it is possible to easily create a mail showing an outline of what kind of information the transmission target information is.

  In the transmission target output device of the present invention, in the transmission target output device, the transmission target information is information acquired by using a query, and the body information acquisition unit specifies transmission target information indicated by the transmission instruction. This is a transmission target output device that acquires text related information obtained by adding information acquired from a query to text related information associated with target specifying information.

  With this configuration, it is possible to create an email with the query information used when acquiring the transmission target information. For example, it is easy to send an email that outlines what information the transmission target information is. Can be created.

  In the transmission target output device according to the present invention, the output unit is a transmission target output device that outputs the transmission target information as an attached file of an email.

  With such a configuration, it is possible to easily create an electronic mail having an appropriate content according to the attached file.

  The transmission target output device of the present invention is a transmission target output device in which the output of the output unit is delivery of one or more transmission target information and text related information to an electronic mail processing unit that transmits mail.

  With this configuration, it is possible to cause the e-mail processing unit to create an e-mail with appropriate content according to the transmission target.

  According to the transmission target output device or the like according to the present invention, when transmitting information to be transmitted by electronic mail, it is possible to easily create an electronic mail having appropriate contents according to the transmission target.

The block diagram of the information processing apparatus provided with the transmission object output apparatus in embodiment of this invention Flowchart for explaining the operation of the transmission target output device The figure which shows the example of a display by the output object output device The figure which shows the transmission object information management table of the transmission object output device The figure which shows the target mail information management table of the same transmission target output device The figure which shows the example of a display of the mail created according to the output of the output object output device The figure which shows an example of the external appearance of the computer system in embodiment of this invention The figure which shows an example of a structure of a computer system

  Hereinafter, embodiments of a transmission target output device and the like will be described with reference to the drawings. In addition, since the component which attached | subjected the same code | symbol in embodiment performs the same operation | movement, description may be abbreviate | omitted again.

(Embodiment)
FIG. 1 is a block diagram of an information processing apparatus 1000 including a transmission target output apparatus 1 according to this embodiment. The information processing apparatus 1000 includes a transmission target output device 1 and an email processing unit 201. The transmission target output device 1 and the e-mail transmission unit 201 are connected to be communicable via a signal line, a bus, or the like. Although not described here, the e-mail processing unit 201 is connected to, for example, another server device or terminal device (not shown) via a network or the like.

  The transmission target output device 1 includes a transmission target storage unit 101, a target mail information storage unit 102, a transmission instruction reception unit 103, a text information acquisition unit 104, and an output unit 105.

  The transmission target storage unit 101 stores one or more pieces of transmission target information. The transmission target information is information to be transmitted. The transmission here is transmission by e-mail, for example. The transmission target information is information transmitted by the e-mail processing unit 201, for example. The transmission target information stored in the transmission target storage unit 101 may be considered as information that can be a transmission target.

  The transmission target information is, for example, table information (hereinafter referred to as table information). A table is an array of numerical values and character strings. The table may have ruled lines, for example. The table is, for example, a table related to a form. The form is, for example, a profit and loss calculation table, a deposit / withdrawal slip, a sales slip, a cash register, a journal, an invoice, a receipt, a delivery note, or the like. The table related to the form may be a form or information created using information included in one or more forms. Further, the table may be a table included in accounting processing software, financial management software, or the like, or a table created by these.

  The table here is a concept including a view of the table. The view is, for example, a table for output (for example, display) different from the one table in which one or more pieces of information stored in one table are arranged. For example, a view for outputting an accounting table in which account items and amounts are stored in association with each other is a table showing a cash book or a table showing a journal. A table view may be thought of as a tabular report created by extracting some information from a database or table. For example, the table may be a table written by a database report writing function or the like.

  The table is, for example, information in which information obtained by searching a part of information stored in a database or a spreadsheet by using a query or the like, or information in which such information is arranged in a template or the like. Also good. For example, a query is information that specifies a database or another table from which data to be placed in a table is acquired, information that specifies a period for acquiring data, attributes or items of information stored in the database, etc. And information specifying the attribute value and the like. The template in which the information acquired by the search or the like is arranged may be a template designated by the user, a template designated in advance, or a template associated with a query, a search instruction, or the like. It may be.

  The table here may be a table created in advance, or may be a table created dynamically according to a user instruction or the like. The user instruction here may be an instruction for designating a table to be displayed, for example, displaying a sales slip.

  The table may be a table created by the user manually inputting at least part of the table.

  The table information is information for outputting a table, for example. The data type or file format of the table information is not limited. The table information may be image data, text data, a combination of text data and information such as a frame line, and the table information includes image data and text data. It may be information. The table information may be information such as a spreadsheet or an HTML file that can be output by a specific device or application software. The table information may be information acquired by electronically printing the table. One table information may be information for outputting a plurality of tables.

  The table information may be information for displaying information in which the table is arranged at least in part. For example, the table information may be information having one or more tables and other information such as text and images.

  In addition, the transmission target information stored in the transmission target storage unit 101 is used to create display image data for a table that is displayed on a display unit (not shown) of the transmission target output device 1 and to generate this image data. It may be considered as the information used for.

  In the transmission target storage unit 101, transmission target information is stored in association with identifiers of transmission target information such as file names, table identifiers such as table titles, and information indicating table types and attributes. Also good. The attributes of the table are information that restricts the browsing target, such as “in-house secret”, “can be browsed only by a department manager or higher”, for example. In addition, the transmission target storage unit 101 stores information used when acquiring transmission target information such as a table, for example, information specifying a query, a table, a database, or the like from which information of the transmission target information is acquired. May be stored in association with the transmission target information.

  There is no limitation on the timing or trigger at which the transmission target information is stored in the transmission target storage unit 101. For example, the transmission target information may be stored in advance in the transmission target storage unit 101. Also, for example, when the transmission instruction receiving unit 103 described later receives a transmission instruction, the transmission target information is generated and transmitted. It may be accumulated in the target storage unit 101, for example, temporarily stored. As a specific example, when a display unit (not shown) of the transmission target output device 1 displays information such as a table, the transmission instruction reception unit 103 outputs transmission target information corresponding to the displayed information. The transmission target created by the processing unit (not shown) of the transmission target output device 1 or the output unit 105 or the like using the displayed information or the information on which the displayed information is based The information may be accumulated, for example, temporarily stored in the transmission target storage unit 101. The transmission target information created and stored in response to the transmission instruction as described above may be considered as transmission target information specified by a transmission instruction to be described later.

  The storage here is a concept including temporary storage. For example, transmission target information created when performing transmission may be temporarily stored in the transmission target storage unit 101.

  The transmission target storage unit 101 is preferably a non-volatile recording medium, but can also be realized by a volatile recording medium. The same applies to other storage units.

  The target mail information storage unit 102 stores one or more target mail information. The target mail information includes target specifying information and text related information.

  The target specifying information is information for specifying the transmission target information. The target specifying information may be any information as long as it is information that can specify the transmission target information. Further, the target specifying information is not necessarily information that specifies one piece of transmission target information. For example, the target specifying information is a file name or a part of the transmission target information or an extension.

  Further, the target specifying information may be information for specifying a table indicated by the transmission target information, such as a table title. Further, the target specifying information may be information for specifying information used when creating the table indicated by the transmission target information. In this case, a table created using this specified information can be specified as a result. For example, the target specifying information includes information for specifying a template used for creating a table (for example, a template identifier) and information for specifying a query used for creating a table (for example, a query identifier). It may be. Further, the target specifying information may be information (for example, an identifier of a database or a table) that specifies a database or a table that is an acquisition source of information arranged in the table. Further, the target specifying information may be information that specifies the type and attribute of the table associated with the table. Further, the target specifying information may be information specifying a character string or a number included in the table. Further, the target specifying information may be an identifier of a view assigned to the view of the table. Further, the target specifying information may be information for specifying a table or a view type of the table.

  The target specifying information may be information having a regular expression such as a so-called wild card. Further, the target specifying information may be information indicating a condition for specifying the transmission target information or information indicating a conditional expression. The target specifying information may be information having any data structure.

  The text related information is information related to the text of an electronic mail (hereinafter also simply referred to as mail) for transmitting the transmission target information specified by the corresponding target specifying information. The text related information is, for example, information on a mail template. The e-mail template may be a template such as a text or an image arranged in the e-mail, or may be a model of data constituting one e-mail. The text related information is, for example, information having at least one of text data and image data.

  The text related information is, for example, information on a fixed sentence placed in an email. Specifically, the text related information is information on a fixed text that is arranged in a mail text or the like when transmitting transmission target information specified by corresponding target specifying information. For example, this standard sentence is a sentence indicating a greeting sentence, a guidance sentence, a cautionary item, or the like described in a mail text or the like for transmitting transmission target information specified by the corresponding target specifying information.

  In the target mail information storage unit 102, for example, target specifying information for specifying transmission target information, which is table information having a title specified in advance, and mail used when the transmission target information is transmitted by mail are used. Target mail information having text related information which is information of a mail template is stored. As a specific example, the target email information storage unit 102 includes target specific information for specifying table information including “sales schedule” in the title, and “I will report the sales status of this month. The object mail information having the text related information of the character string “is.” Is stored.

  Further, for example, in the target mail information storage unit 102, when target information for specifying the title or file name of a table from which information for creating a table is obtained and this transmission target information are transmitted by mail Target mail information having text related information that is template information of mail used for creating mail is stored. As a specific example, the target email information storage unit 102 includes target specifying information for specifying table information including the title “customer information” as the data acquisition source and “personal information. The target mail information having the text related information of the character string “Be careful in handling.” Is stored. The table specified by the target specifying information may be considered as a table view, for example.

  The text related information indicates information for specifying information acquired from the transmission target information specified by the corresponding target specifying information, and a position where the information acquired from the transmission target information is arranged according to the specified information. You may have information. The information specifying the information acquired from the transmission target information is, for example, information specifying an attribute associated with the information included in the transmission target information, such as an attribute name or information that matches a pattern specified in advance. is there. For example, the information specifying the information acquired from the transmission target information is information specifying the title of the transmission target information, attributes such as date and period.

  The information indicating the position where the information acquired from the transmission target information is arranged may be information that can specify the position where the acquired information is arranged in the text related information. For example, the head or end of the text related information, It may be information specifying the line number, the number of characters from the beginning, or the like, or may be a specific character string or symbol in the text related information to be replaced with the acquired information.

  The information specifying the information acquired from the transmission target information may be considered as information indicated by a variable arranged in the text related information, for example. The information indicating the position where the information acquired from the transmission target information is arranged is, for example, You may think of it as the position where the variable is arranged. As a specific example, in the target email information stored in the target email information storage unit 102, “Please send <variable> as a material to be used at the management meeting. Please confirm.” The information specified by <variable> is information specifying information acquired from the transmission target information, and the position where the "<variable>" is arranged is information indicating the position where the acquired information is arranged. There may be.

  In addition, the text related information is information that specifies information included in the query used when acquiring the transmission target information that is table information, and a position where information acquired from the query is arranged according to the specified information. May be included. The information included in the query is, for example, one or more conditions that the query has. Such information may be considered as one of the variables included in the text related information. The information specifying the information included in the query is, for example, information having a pre-specified attribute in the query, for example, a period, a date, a title, a customer name, etc., which is a value of a condition included in the query. . Further, the information specifying the information included in the query may be information that matches a previously specified pattern in the query. As the information indicating the position where the information acquired from the query is arranged, the same information as the information indicating the position where the information acquired from the transmission target information is arranged can be used.

  The information specifying the information acquired from the query may be considered as the information indicated by the variable arranged in the text related information, for example, and the information indicating the position where the information acquired from the query is arranged is, for example, the variable You may think that it is the position where it is arranged.

  The target mail information may further include one or more destination information that is information indicating the destination of the mail. The destination information is, for example, address information such as a mail address indicating a mail destination. Further, it may be a nickname associated with this address information, a group ID associated with a plurality of address information, or the like. In addition, the destination information is the account or nickname of the destination of the email when the email is an email whose address can be specified by an account, nickname, etc., such as an SNS (social network service) email. Also good. In the case of mail in which the user's mobile phone number can be used as the mail destination, the transmission destination information may be a mobile phone number.

  The transmission instruction receiving unit 103 receives a transmission instruction that is an instruction to transmit one or more pieces of transmission target information. The transmission instruction may be an instruction to transmit one or more pieces of transmission target information stored in the transmission target storage unit 101, for example. The transmission instruction may be an instruction to transmit transmission target information such as table information displayed on a display unit (not shown). In addition, the transmission instruction includes an instruction to create and transmit data for display of information such as a table displayed on a display unit (not shown), and transmission target information corresponding to data that is the source of the display data. You may think. For example, the transmission instruction is obtained from display data for information such as a table displayed by a display unit (not shown), data obtained by electronically printing the original data, or the displayed data. Screen shot data or the like may be considered as an instruction for transmission. Further, the transmission instruction may be considered as an instruction to transmit the transmission target information as an email attachment.

  The transmission instruction has information for specifying transmission target information, for example. It does not matter how the transmission instruction specifies transmission target information. For example, the transmission instruction may have a file name or the like associated with the transmission target information as information for specifying the transmission target information. Further, the transmission instruction may have a pointer indicating a position where the transmission target information is stored as information specifying the transmission target information.

  The reception here is a concept including reception of information input from an input device such as a keyboard, a mouse, and a touch panel, reception of information transmitted via a wired or wireless communication line, and the like.

  The transmission instruction input means may be anything such as a numeric keypad, keyboard, mouse, or menu screen. The transmission instruction receiving unit 103 can be realized by a device driver for input means such as a numeric keypad or a keyboard, control software for a menu screen, and the like.

  The text information acquisition unit 104 acquires the text related information associated with the target specifying information for specifying the transmission target information indicated by the transmission instruction received by the transmission instruction receiving unit 103 using the target mail information. For example, the body information acquisition unit 104 reads the transmission target information indicated by the transmission instruction from the transmission target storage unit 101, and stores the target identification information that identifies the transmission target information that is read out in the target mail information storage unit 102. It is detected from the target specifying information possessed by one or more text mail information. Then, the text related information is acquired from the text mail information having the detected target specifying information.

  For example, the text information acquisition unit 104 sequentially reads the target specifying information that each of the one or more text mail information stored in the target mail information storage unit 102 has, and the transmission target information indicated by the transmission instruction is the target specification. It is determined whether the information is specified by the information. When it is determined that the information is specified, the text related information included in the text mail information having the target specifying information is acquired.

  The body information acquisition unit 104 may further acquire the destination information associated with the target identification information for specifying the transmission target information indicated by the transmission instruction received by the transmission instruction reception unit 103 using the target mail information. Good. For example, the text information acquisition unit 104 acquires the destination information included in each of the one or more text mail information that acquired one or more text related information.

  In addition, the text information acquisition unit 104 adds the information acquired from the transmission target information to the text related information associated with the target identification information that specifies the transmission target information indicated by the transmission instruction received by the transmission instruction reception unit 103. The text related information may be acquired. The information acquired from the transmission target information is, for example, a table title such as a title or a table name such as a table name. The text related information associated with the target specifying information for specifying the transmission target information indicated by the transmission instruction received by the transmission instruction receiving unit 103 is, for example, the text related information acquired from the text mail information as described above.

  For example, the text information acquisition unit 104 acquires, from the transmission target information, information specified in advance, for example, information having a previously specified attribute or information that matches a pattern specified in advance, and acquires the acquired information. Is acquired at an arbitrary position of the text related information associated with the target specifying information for specifying the transmission target information indicated by the transmission instruction, or the text related information arranged at a predesignated position.

  In addition, as described above, the text related information associated with the target specifying information for specifying the transmission target information indicated by the transmission instruction received by the transmission instruction receiving unit 103 is information specifying the information acquired from the transmission target information. If it has, the text information acquisition unit 104 may acquire the information to be designated from the transmission target information and acquire text related information in which the acquired information is arranged.

  Further, the text related information associated with the target specifying information for specifying the transmission target information indicated by the transmission instruction received by the transmission instruction receiving unit 103 has information indicating the position where the information acquired from the transmission target information is arranged. If it is, the text information acquisition unit 104 may acquire text related information in which the information acquired from the transmission target information is arranged at the position indicated by the information indicating this position of the text related information.

  When the transmission target information indicated by the transmission instruction is information acquired using a query, for example, table information such as a table view, the text information acquisition unit 104 receives the transmission instruction received by the transmission instruction reception unit 103. The text related information obtained by adding the information acquired from the query to the text related information associated with the target specifying information for specifying the transmission target information indicated by may be acquired. The text related information associated with the target specifying information for specifying the transmission target information indicated by the transmission instruction received by the transmission instruction receiving unit 103 is, for example, the text related information acquired from the text mail information as described above. Note that the query used when acquiring the transmission target information may be accumulated in the transmission target storage unit 101, a storage unit (not shown), or the like in association with the transmission target information, for example.

  For example, the body information acquisition unit 104 acquires information specified in advance from a query used to acquire transmission target information, for example, information having a specified attribute or information that matches a specified pattern. To obtain the text-related information that is placed at any position of the text-related information associated with the target identification information that identifies the transmission target information indicated by the transmission instruction, or at a position specified in advance. To do.

  Further, as described above, the text related information associated with the target specifying information for specifying the transmission target information indicated by the transmission instruction received by the transmission instruction receiving unit 103 includes information for specifying information acquired from the query. If it is, the text information acquisition unit 104 may acquire the information to be specified from the query used to acquire the transmission target information, and acquire text related information in which the acquired information is arranged.

  Further, the text related information associated with the target specifying information for specifying the transmission target information indicated by the transmission instruction received by the transmission instruction receiving unit 103 includes information indicating the position where the information acquired from the query is arranged. In this case, the text information acquisition unit 104 may acquire text related information in which the information acquired from the query is arranged at the position indicated by the information indicating this position of the text related information.

  The text information acquisition unit 104 can be usually realized by an MPU, a memory, or the like. The processing procedure of the text information acquisition unit 104 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The output unit 105 outputs one or more pieces of transmission target information indicated by the transmission instruction and the text related information acquired by the text information acquisition unit 104. For example, the output unit 105 outputs the transmission target information and the text related information to the e-mail processing unit 201. The output here may be considered as the delivery of data to the e-mail processing unit 201.

  The output unit 105 outputs the text related information as the text information of the mail or as the template information of the mail.

  For example, the output unit 105 outputs the transmission target information as an email attachment. When outputting the transmission target information, the output unit 105 may create a file in a file format designated in advance from the transmission target information. Here, the transmission target information created in this way may be considered to be substantially the same as the original transmission target information. In addition, processing such as compression may be performed on the transmission target information. Further, a file name determined by a rule designated in advance, for example, a file name obtained by adding a date and a transmission number may be added to the transmission target information.

  The output unit 105 may further output the transmission destination information acquired by the text information acquisition unit 104 to the electronic mail apparatus.

  The output unit 105 may further output an instruction for starting the e-mail processing unit 201, an instruction for causing the e-mail processing unit 201 to create a mail, an instruction for creating a mail having transmission target information, and the like.

  Instead of transmitting the transmission target information and the text related information to the e-mail processing unit 201, the output unit 105 transmits one or more transmission target information indicated by the transmission instruction and the text related acquired by the text information acquisition unit 104. A mail having information, for example, a mail having information to be transmitted as an attached file and text-related information arranged in the text of the mail is created and displayed on a monitor (not shown) of the information processing apparatus 1000. The created mail may be transmitted in response to such an instruction. Alternatively, the output unit 105 may create a mail having transmission target information and text related information, and transmit the mail to a transmission destination indicated by the transmission destination information.

  The output here is a concept including display on a display, transmission to an external device, accumulation in a recording medium, delivery of a processing result to another processing device or another program, and the like.

  The output unit 105 may be considered as including or not including a communication unit and an output device such as a display device. The output unit 105 can be realized by, for example, output device driver software, or output device driver software and an output device.

  The e-mail processing unit 201 receives the transmission target information and the text related information output from the output unit 105 of the transmission target output device 1. Then, the e-mail processing unit 201 creates a mail having the received transmission target information and text related information. For example, a mail having the transmission target information as an attached file and text-related information arranged in the mail text is created. For example, the e-mail processing unit 201 displays the created mail on a monitor (not shown) of the information processing apparatus 1000. The e-mail processing unit 201 accumulates, for example, a mail address received from a user or the like in a storage unit (not shown) in association with the created mail. Then, for example, the e-mail processing unit 201 transmits the created e-mail to the e-mail address associated with this e-mail in response to an e-mail transmission instruction received from the user or the like.

  Further, the e-mail processing unit 201 may further receive transmission destination information from the output unit 105 of the transmission target output device 1. The e-mail processing unit 201 creates, for example, an e-mail having the transmission target information and the text-related information received as described above, and associating this transmission destination information as e-mail transmission destination information. You may display on a monitor etc. And according to the mail transmission instruction | indication received from the user etc., you may make it transmit the produced mail to the transmission destination which transmission destination information shows. Note that the e-mail processing unit 201 may transmit the created mail to the transmission destination indicated by the transmission destination information without displaying it on a monitor or the like.

  An accepting unit (not shown) accepts an editing operation for a mail displayed on a monitor or the like from a user or the like, and the e-mail processing unit 201 edits the displayed mail in response to the editing operation. It may be. Then, the email processing unit 201 may transmit the edited email.

  The e-mail processing unit 201 may receive e-mail transmitted from the outside, for example.

  The e-mail processing unit 201 is realized by an application program such as a so-called mailer that causes a computer to execute a function of transmitting an e-mail. However, the e-mail processing unit 201 may be realized by dedicated hardware.

  Next, an example of the operation of the transmission target output device 1 will be described using the flowchart of FIG.

  (Step S101) The transmission instruction receiving unit 103 determines whether a transmission instruction has been received. If accepted, the process proceeds to step S102. If not accepted, the process returns to step S101.

  (Step S102) The text information acquisition unit 104 reads the transmission target information indicated by the transmission instruction received in Step S101 from the transmission target storage unit 101.

  (Step S103) The text information acquisition unit 104 assigns 1 to the value of the counter m.

  (Step S <b> 104) The text information acquisition unit 104 determines whether or not the m-th target mail information is stored in the target mail information storage unit 102. If stored, the process proceeds to step S105. If not stored, the process proceeds to step S112.

  (Step S105) The text information acquisition unit 104 determines whether or not the transmission target information read in Step S102 is information specified by the target specifying information included in the mth target mail information. For example, the text information acquisition unit 104 determines whether or not the transmission target information or the information used for acquiring the transmission target information is information that satisfies the condition indicated by the target identification information. If it is information to be specified, the process proceeds to step S106, and if it is not information to be specified, the process proceeds to step S111.

  (Step S106) The text information acquisition unit 104 acquires a set of text related information and destination information from the m-th target mail information. The acquired information is temporarily stored in a storage unit (not shown).

  (Step S107) The text information acquisition unit 104 determines whether or not the information included in the transmission target information read in step S102 needs to be arranged in the text related information acquired in step S106. For example, it is determined whether the text related information includes information specifying information acquired from the transmission target information and information specifying a position where the information acquired from the transmission target information is arranged. If it is necessary to place the object, the process proceeds to step S108, and if not, the process proceeds to step S109.

  (Step S108) The text information acquisition unit 104 acquires the information included in the transmission target information read in step S102 and arranges it in the text related information stored above.

  (Step S109) The text information acquisition unit 104 determines whether the information acquired from the query used to acquire the transmission target information read in step S102 needs to be arranged in the text related information. For example, it is determined whether the text related information includes information specifying information acquired from a query and information specifying a position where information acquired from a query is arranged. If there is a need to place, the process proceeds to step S110, and if not, the process proceeds to step S111.

  (Step S110) The text information acquisition unit 104 acquires information from the query stored in the transmission target storage unit 101 or the like in association with the transmission target information read in Step S102, and stores the text stored above. Place in related information.

  (Step S111) The text information acquisition unit 104 increments the value of the counter m by 1. Then, the process returns to step S104.

  (Step S112) The output unit 105 outputs one or more sets of the text related information and the transmission destination information acquired in Step S106 and the transmission target information read in Step S102. For example, it is output to the e-mail processing unit 201. Then, the process ends. Here, the set of the text related information and the transmission destination information in which the information acquired in step S108 or step S110 is arranged is also considered as the set of the text related information and the transmission destination information acquired in step S106. Note that if there are a plurality of sets of the text related information and the destination information acquired in step S106, the output unit 105 sets the text related information and each set of the text related information and the destination information, Information associated with each may be output. In this case, for example, the e-mail processing unit 201 creates, for each set of text related information and destination information, an email having text related information and transmission target information whose destination is the destination indicated by the destination information. May be.

  Hereinafter, a specific operation of the information processing apparatus 1000 in the present embodiment will be described.

  Here, as an example, the transmission target output device 1 of the information processing apparatus 1000 displays information acquired by a query or the like from a database or the like (not shown) in which information related to corporate accounting processing is stored on a monitor or the like (not shown). A case where the apparatus is possible will be described.

  For example, if the user performs an operation of selecting a menu item for displaying a table titled “Departmental Income Statement” on the transmission target output device 1 via an input device (not shown) or the like, In response to this operation, the output device 1 displays, on a monitor (not shown), an input field or the like for requesting an input of a total period required for creating a query for acquiring data to be arranged in the “Department Income Statement” table. indicate.

  Then, it is assumed that the user inputs information specifying the start date as April 1, 2013 and the end date as March 31, 2014 as information indicating the total period. The transmission target output device 1 creates a query using the input information, and acquires information corresponding to the query from a database (not shown). The created query is, for example, a query created by replacing the variable portion of the query previously associated with the menu item with the information of the total period input above. This database may be provided in the information processing apparatus 1000, or may be included in an external server apparatus connected via a network or the like.

  Next, read a table template or the like indicating a “department profit / loss statement” stored in a storage unit (not shown) in advance, and place the information acquired from the database using a query in the table template. Create table information for the "Profit and Loss Statement by Division". This template is, for example, a template previously associated with the menu item. The file name of the created table information is, for example, a file name created according to a rule specified in advance. Specifically, the file name is a character string in which the character string “Department Profit and Loss Statement” that is the title of the created table and the character string indicating the month of the end date of the query used for creation are arranged. It is assumed that the file name is “Departmental profit and loss statement (April)” determined according to the rule. Here, the file name and the title are different character strings. The created table information is stored in the transmission target storage unit 101 in association with the file name.

  Further, a display unit (not shown) of the information processing apparatus 1000 displays the table created above on a monitor or the like (not shown). The transmission target output device 1 may have a display unit (not shown) of the information processing apparatus 1000.

  FIG. 3 is a diagram showing a “department profit / loss statement (April)” which is a table displayed by the transmission target output device 1.

  Here, it is assumed that other table information has already been created and this table is displayed in a different window (not shown) on the monitor.

  FIG. 4 is a transmission target information management table for managing transmission target information stored in the transmission target storage unit 101. The transmission target information management table has attributes of “ID”, “transmission target”, and “query”. “ID” is an identifier for managing a record (row) of the transmission target information management table. “Transmission target” is transmission target information, and here, the file name of the transmission target information is shown. The transmission target information is, for example, a file having a combination of a style sheet for specifying a table ruled line, a position where data is arranged, and XML data. The extension etc. are omitted. “Query” is a query used to create table information. Note that the queries shown here are for convenience of explanation, and are not necessarily usable as actual queries.

  The table shown in FIG. 3 is a table corresponding to the record whose “ID” is “002” in the transmission target information management table shown in FIG. As described above, the title of this table is “Departmental Income Statement” and is displayed in the area 30 of FIG.

  Next, if the user performs an operation of transmitting the transmission target information corresponding to the table being displayed in FIG. 4, that is, the table information, using an input device (not shown), the transmission instruction receiving unit 103 3, a transmission instruction for transmitting transmission target information whose table name corresponds to the table shown in FIG.

  When the transmission instruction receiving unit 103 receives the transmission instruction, the table information that is the transmission target information whose file name is “Departmental Income Statement (April)” from the transmission target storage unit 101 is stored in a storage unit such as a memory (not shown). read out.

  FIG. 5 is a target mail information management table for managing target mail information stored in the target mail information storage unit 102. The target mail information management table has attributes of “ID”, “target specific information”, “text related information”, “subject”, and “transmission destination”. “ID” is an identifier for managing a record (row) of the target mail information management table. “Target specifying information” is target specifying information. For example, it is assumed that “title: (character string)” is information for specifying transmission target information whose title includes “(character string)”. Note that “(character string)” indicates an arbitrary character string. This also applies to the following. Further, “query FROM: (character string)” is information specifying transmission target information acquired using a query whose value of “FROM” includes “(character string)”. The “FROM” of the query here is an attribute indicating an identifier of a table or database that is an acquisition destination for acquiring data by the query, for example. The “text related information” is text related information, and here it is assumed to be text data. Note that the character string enclosed in the characters “<$” and “$>” in the text related information specifies, for example, the character string acquired from the transmission target information or query, and the position where the acquired character string is arranged. It is assumed that the information is For example, when the character string between “<$” and “$>” is “transmission target: (character string)”, the attribute is “(character string)” from the transmission target information here. It means that information is acquired and arranged. For example, when the character string between “<$” and “$>” is “query: (character string)”, the attribute “(” is obtained from the query associated with the transmission target information. This means that the attribute value of “character string” ”is acquired and arranged. “Subject” is the subject of the mail. Since the subject of the email is related to the text, the subject of the email may or may not be considered as text related information. The “transmission destination” in the text is transmission destination information, and here it is assumed to be a mail address.

  Here, “target identification information” is expressed in natural language, but “target identification information” is, for example, one or more functions corresponding to these natural languages, method names, “if”, It may be configured with a control syntax indicated by “then” or the like. Further, the “target identification information” may be an algorithm for performing determination processing corresponding to these natural languages.

  Next, the text information acquisition unit 104 sets the “specific target information” value “title: sales details” from the record whose “ID” value is the smallest value “01” in the target mail information management table shown in FIG. Is obtained. Then, it is determined whether or not the transmission target information whose file name read into the storage unit such as the memory is “Department Profit and Loss Statement (April)” is the transmission target information specified by the specification target information. To do.

  Since the target specifying information “title: sales details” is information for specifying transmission target information including the character string “sales details” as described above, the body information acquiring unit 104 reads the transmission target that has been read. From the information, the title “Profit / Loss Statement by Division” is acquired, and it is determined whether or not the title includes the character string “detailed sales”. Since it is not included here, the text information acquisition unit 104 determines that the read transmission target information is not information specified by the target specification information.

  Next, the body information acquisition unit 104 acquires the “specific target information” value “query FROM: CustomerSheet” of the record whose “ID” value is “02” from the target mail information management table shown in FIG. . Then, it is determined whether or not the transmission target information whose file name read into the storage unit such as the memory is “Department Profit and Loss Statement (April)” is the transmission target information specified by the specification target information. To do.

  Since the target specifying information “query FROM: CustomerSheet” is information specifying the transmission target information acquired using a query whose value of “FROM” includes “CustomerSheet”, the body information acquiring unit 104 has read the information. The value of “query” corresponding to the transmission target information “department profit / loss management table (April)” is read from the transmission target information management table shown in FIG. 4, and the FROM attribute value of the read query is “CustomerSheet”. Whether or not is included. Here, the attribute value of “FROM” of the “query” of the record whose “ID” is “002” in FIG. 4, that is, the character string immediately after “FROM” is “ProfitSheet” and includes “CustomerSheet”. Therefore, it is determined that the transmission target information is not information specified by the target specifying information.

  Next, the text information acquisition unit 104 obtains the value “title: income statement” of the “specific target information” from the record whose “ID” value is “03” in the target mail information management table shown in FIG. get. Then, the title “departmental profit and loss statement” is acquired from the transmission target information read into the storage unit such as the memory, and it is determined whether or not the title includes the character string “loss statement”. Since it is included here, the text information acquisition unit 104 determines that the read transmission target information is information specified by the target specification information.

  Since it is determined that the transmission target information is specified by the target identification information, the “text related information” value and the “subject” value of the record whose “ID” is “03” in the target mail information management table A set of “material of management meeting” and “staff03 @ obc...” Which is the value of “transmission destination” is acquired and stored in a storage unit (not shown).

  Next, the text information acquisition unit 104 determines whether or not the accumulated “text related information” is information that needs to be arranged in the information included in the transmission target information. Here, it is determined whether or not the character string “<$ transmission target:” is included in the “text related information”. The acquired character string is "Thank you very much. We will send <$ Sent: Title $> as the material to be used at the next week's management meeting, so please check it. The period of the material is <$ Query: From <period start date $> to <$ query: period end date $> ... "and only one character string" <$ transmission target: "is included. Judge that placement is necessary.

  Then, according to the character string “title” surrounded by “<$ transmission target:” and “$>” immediately after this, the “department profit / loss statement” which is the title is acquired from the transmission target information. The character string “<$ transmission target: title $>” is replaced with the obtained character string “departmental income statement”.

  Further, the text information acquisition unit 104 determines whether or not the accumulated “text related information” is information that requires the arrangement of information included in the query used to acquire the transmission target information. Here, it is determined whether or not the character string “<$ query:” is included in the “text related information”. Since the acquired character string includes “<$ query: period start date $>” and “<$ query: period end date $>”, it is determined that the information included in the query needs to be arranged. To do.

  First, for the first “<$ query: period start date $>”, information corresponding to the character string “period start date” surrounded by “<$ query:” and immediately after “$>” is obtained. Obtained from the query associated with the transmission target information. Specifically, information corresponding to the character string “period start date” is acquired from the “query” value of the record whose “ID” is “002” in FIG. Here, for example, as a value corresponding to “period start date”, a character string sandwiched between “#” immediately after “Between” in the value of “WHERE” in the query, specifically a numeric string Is acquired in advance, the body information acquiring unit 104 acquires “2013/4/1” from the query. Then, the character string “<$ query: period start date $>” in the text related information is replaced with the acquired character string. Note that the character string may be replaced after being converted into a format designated in advance. For example, “2013/4/1” may be replaced with a character string “April 1, 2013”.

  In addition, the text information acquisition unit 104 sets the character string “period start date” surrounded by “<$ query:” and “$>” immediately after it for the second “<$ query: period end date $>”. Is obtained from the query associated with the transmission target information. Specifically, information corresponding to the character string “period start date” is acquired from the “query” value of the record whose “ID” is “002” in FIG. Here, for example, as a value corresponding to “period start date”, a character string sandwiched between “#” immediately after “And” immediately after “Between” in the value of “WHERE” in the query, Specifically, if acquisition of a numeric string is specified in advance, the body information acquisition unit 104 acquires “2014/3/31” from the query. Then, the character string “<$ query: period end date $>” in the text related information is replaced with the acquired character string. As a result, the text-related information stored is “Thank you for your hard work. We will send you a profit and loss statement for each department as a document to be used at the next week's management meeting, so please check it. / 4/1 to 2014/3/31 ... "

  The body text information acquisition unit 104 performs the same process for all records whose “ID” in the target mail information management table shown in FIG. Then, it is assumed that the combination of the acquired text related information and the destination information is only the combination acquired from the record whose “ID” in the target mail information management table is “03”. However, a part of the text related information acquired here is replaced with the information included in the transmission target information and the information included in the query as described above.

  Next, the output unit 105 transmits the transmission target information indicated by the transmission instruction, that is, the table information whose file name is “Departmental profit / loss management table (April)”, the text related information acquired by the text information acquisition unit 104, The subject and the mail address that is the destination information are passed to the e-mail processing unit 201. The output unit 105 is, for example, a mail in which text related information is placed in a mail text, a subject is placed in a mail subject field, and transmission target information is attached as an attached file, and a destination mail address is set as a destination. Along with an instruction to create a mail with the mail address indicated by the information, the information is passed to the electronic mail processing unit 201.

  The e-mail processing unit 201 uses the information received from the output unit 105 to arrange body-related information in the body of the email, place the subject in the subject field of the email, and attach the transmission target information as an attached file. Thus, a mail whose destination mail address is the mail address indicated by the destination information is created. Then, the created mail is displayed on a display unit (not shown).

  FIG. 6 is a diagram showing a display example of mail created by the email processing unit 201.

  Then, the mail shown in FIG. 6 is transmitted when the user performs a mail transmission operation or the like via a reception unit (not shown).

  As described above, according to the present embodiment, since the text related information associated with the target specifying information for specifying the transmission target information is output together with the transmission target information, when transmitting the transmission target information by e-mail, It is possible to easily create an e-mail with appropriate contents according to the transmission target.

  In the above embodiment, each process (each function) may be realized by centralized processing by a single device (system), or by distributed processing by a plurality of devices. May be.

  In the above embodiment, information related to processing executed by each component, for example, information received, acquired, selected, generated, transmitted, and received by each component. In addition, information such as threshold values, mathematical formulas, addresses, etc. used by each component in processing is retained temporarily or over a long period of time on a recording medium (not shown) even when not explicitly stated in the above description. It may be. Further, the storage of information in the recording medium (not shown) may be performed by each component or a storage unit (not shown). Further, reading of information from the recording medium (not shown) may be performed by each component or a reading unit (not shown).

  In the above embodiment, the case where the transmission target output device and the information processing device are stand-alone has been described. However, the transmission target output device and the information processing device may be a stand-alone device in a server / client system. It may be a server device. In the latter case, the output unit or the reception unit receives an input or outputs a screen via a communication line.

  In the above embodiment, each component may be configured by dedicated hardware, or a component that can be realized by software may be realized by executing a program. For example, each component can be realized by a program execution unit such as a CPU reading and executing a software program recorded on a recording medium such as a hard disk or a semiconductor memory. At the time of execution, the program execution unit may execute the program while accessing a storage unit (for example, a recording medium such as a hard disk or a memory).

  Note that the software that realizes the transmission target output device in the above embodiment is the following program. That is, this program includes a transmission target storage unit that stores one or more pieces of transmission target information that is transmission target information, target specification information that is information for specifying transmission target information, and transmission specified by the target specification information. One or more transmission target information includes a computer that can access one or more target mail information storage units that store one or more target mail information having text related information that is information related to a text of a mail for transmitting the target information. Text information acquisition that uses the target mail information to acquire the text related information associated with the target specifying information for specifying the transmission target information indicated by the transmission instruction And a program for functioning as an output unit that outputs one or more transmission target information indicated by the transmission instruction and text related information acquired by the text information acquisition unit It is.

  In the program, the functions realized by the program do not include functions that can be realized only by hardware. For example, a function that can be realized only by hardware such as a modem or an interface card in an acquisition unit that acquires information or an output unit that outputs information is not included in the function realized by the program.

  Further, the computer that executes this program may be singular or plural. That is, centralized processing may be performed, or distributed processing may be performed.

  In addition, the software that realizes the transmission target output device and the software that realizes the electronic mail processing unit in the above embodiment may be considered as two pieces of software executed by one computer.

  FIG. 7 is a schematic diagram illustrating an example of an external appearance of a computer that executes the program and realizes the transmission target output apparatus and the information processing apparatus according to the above-described embodiment. The above-described embodiment can be realized by computer hardware and a computer program executed on the computer hardware.

  In FIG. 7, a computer system 900 includes a computer 901 including a CD-ROM (Compact Disk Read Only Memory) drive 905, a keyboard 902, a mouse 903, and a monitor 904.

  FIG. 8 is a diagram showing an internal configuration of the computer system 900. In FIG. 8, in addition to the CD-ROM drive 905, a computer 901 is connected to an MPU (Micro Processing Unit) 911, a ROM 912 for storing a program such as a bootup program, and the MPU 911, and receives instructions of an application program. A RAM (Random Access Memory) 913 that temporarily stores and provides a temporary storage space, a hard disk 914 that stores application programs, system programs, and data, and a bus 915 that interconnects the MPU 911, ROM 912, and the like Prepare. The computer 901 may include a network card (not shown) that provides connection to the LAN.

  A program that causes the computer system 900 to execute the functions of the transmission target output device, the information processing device, and the like according to the above-described embodiment is stored in the CD-ROM 921, inserted into the CD-ROM drive 905, and transferred to the hard disk 914. Also good. Instead, the program may be transmitted to the computer 901 via a network (not shown) and stored in the hard disk 914. The program is loaded into the RAM 913 when executed. The program may be loaded directly from the CD-ROM 921 or the network.

  The program does not necessarily include an operating system (OS), a third-party program, or the like that causes the computer 901 to execute the function of the transmission target output device according to the above embodiment. The program may include only a part of an instruction that calls an appropriate function (module) in a controlled manner and obtains a desired result. How the computer system 900 operates is well known and will not be described in detail.

  The present invention is not limited to the above-described embodiments, and various modifications are possible, and it goes without saying that these are also included in the scope of the present invention.

  As described above, the transmission target output device according to the present invention is suitable as a device that outputs information to be transmitted, and is particularly useful as a device that outputs information to be transmitted by e-mail.

DESCRIPTION OF SYMBOLS 1 Transmission object output apparatus 1000 Information processing apparatus 101 Transmission object storage part 102 Object mail information storage part 103 Transmission instruction | indication reception part 104 Text information acquisition part 105 Output part 201 E-mail processing part

Claims (8)

A transmission target storage unit that stores one or more pieces of transmission target information that is information to be transmitted;
One or more target mail information including target specifying information that is information for specifying transmission target information and text related information that is information related to a text of an email for transmitting the transmission target information specified by the target specifying information. A target email information storage unit to be stored;
A transmission instruction receiving unit that receives a transmission instruction that is an instruction to transmit the one or more pieces of transmission target information;
A text information acquisition unit that acquires text related information associated with target specifying information for specifying transmission target information indicated by the transmission instruction using the target mail information;
An output unit that outputs one or more pieces of transmission target information indicated by the transmission instruction and text related information acquired by the text information acquisition unit ;
The transmission target information is table information,
The target identification information includes the title of the table indicated by the transmission target information, information identifying the template used to create the table, information identifying the query used when creating the table, and information arranged in the table A transmission target output device which is information identifying a database or table from which data is acquired, information identifying a character string or number included in the table, or an identifier assigned to a view of the table . The target email information further includes destination information that is information indicating a destination of the email,
The body information acquisition unit further acquires, using the target mail information, transmission destination information associated with target specifying information for specifying transmission target information indicated by the transmission instruction,
The transmission target output device according to claim 1, wherein the output unit further outputs the transmission destination information acquired by the text information acquisition unit. The said text information acquisition part acquires the text relevant information which added the information acquired from the said transmission target information to the text relevant information matched with the target specific information which specifies the transmission target information which the said transmission instruction | indication shows. The transmission target output device according to claim 1 or 2. The transmission target information is information acquired using a query,
The said text information acquisition part acquires the text relevant information which added the information acquired from the said query to the text relevant information matched with the target specific information which specifies the transmission target information which the said transmission instruction shows. The transmission target output device according to claim 3. The transmission target output device according to any one of claims 1 to 4, wherein the output unit outputs the transmission target information as a mail attachment file. The transmission target output according to any one of claims 1 to 5, wherein the output of the output unit is a delivery of the one or more transmission target information and text related information to an e-mail processing unit that transmits mail. apparatus. A transmission target storage unit that stores one or more pieces of transmission target information that is transmission target information, target identification information that is information for identifying transmission target information, and transmission target information that is identified by the target identification information are transmitted. A target mail information storage unit that stores one or more target mail information having text related information that is information related to the text of the email for use, a transmission instruction reception unit, a text information acquisition unit, and an output unit A transmission target output method to be performed,
A transmission instruction receiving step in which the transmission instruction receiving unit receives a transmission instruction that is an instruction to transmit the one or more pieces of transmission target information;
A text information acquisition step in which the text information acquisition unit acquires text related information associated with target specifying information for specifying transmission target information indicated by the transmission instruction using the target mail information;
The output unit includes one or more transmission target information indicated by the transmission instruction, and an output step of outputting the text related information acquired in the text information acquisition step ,
The transmission target information is table information,
The target identification information includes the title of the table indicated by the transmission target information, information identifying the template used to create the table, information identifying the query used when creating the table, and information arranged in the table A transmission target output method that is information for identifying a database or table from which data is acquired, information for identifying a character string or number included in the table, or an identifier assigned to a view of the table . A transmission target storage unit that stores one or more pieces of transmission target information that is transmission target information, target identification information that is information for identifying transmission target information, and transmission target information that is identified by the target identification information are transmitted. A target mail information storage unit that stores one or more target mail information having text related information that is information related to the text of the email for
A transmission instruction receiving unit that receives a transmission instruction that is an instruction to transmit the one or more pieces of transmission target information;
A text information acquisition unit that acquires text related information associated with target specifying information for specifying transmission target information indicated by the transmission instruction using the target mail information;
Function as an output unit that outputs one or more pieces of transmission target information indicated by the transmission instruction and the text related information acquired by the text information acquisition unit ;
The transmission target information is table information,
The target identification information includes the title of the table indicated by the transmission target information, information identifying the template used to create the table, information identifying the query used when creating the table, and information arranged in the table A program that is information that identifies a database or table from which it is obtained, information that identifies a string or number contained in a table, or an identifier assigned to a view of a table .