CN111210203B - E-mail distribution method, system, medium and equipment - Google Patents

E-mail distribution method, system, medium and equipment Download PDF

Info

Publication number
CN111210203B
CN111210203B CN202010016607.4A CN202010016607A CN111210203B CN 111210203 B CN111210203 B CN 111210203B CN 202010016607 A CN202010016607 A CN 202010016607A CN 111210203 B CN111210203 B CN 111210203B
Authority
CN
China
Prior art keywords
mail
parameter configuration
configuration information
mails
recipient
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202010016607.4A
Other languages
Chinese (zh)
Other versions
CN111210203A (en
Inventor
张冕
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Si Tech Information Technology Co Ltd
Original Assignee
Beijing Si Tech Information Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Si Tech Information Technology Co Ltd filed Critical Beijing Si Tech Information Technology Co Ltd
Priority to CN202010016607.4A priority Critical patent/CN111210203B/en
Publication of CN111210203A publication Critical patent/CN111210203A/en
Application granted granted Critical
Publication of CN111210203B publication Critical patent/CN111210203B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/107Computer-aided management of electronic mailing [e-mailing]

Abstract

The invention relates to an email distribution method, system, medium and equipment. The method comprises the following steps: receiving mail parameter configuration information filled in a sheet page of Excel, and generating mails with corresponding contents according to the mail parameter configuration information; when receiving the mail sending trigger information, circularly calling a corresponding mail server according to the mail parameter configuration information to carry out mail distribution. The invention simplifies the complicated batch operation by automatic execution, realizes batch and point-to-point mode for sending mails with different contents to different users, and can obtain expected results by clicking a mail sending button on an interface only by a certain configuration, thereby greatly improving the working efficiency; and the batch distribution logic does not cause instantaneous pressure on the mail server, so that the operation is more stable and reliable.

Description

E-mail distribution method, system, medium and equipment
Technical Field
The present invention relates to the field of information security technologies, and in particular, to a method, a system, a medium, and an apparatus for distributing electronic mail.
Background
Currently, inside a company, there are often such scenarios: the manager needs to periodically send monthly performance scores (in tabular form), HR executives to distribute various digital version benefits (in HTML mail form) to the staff members point-to-point, etc.
However, common mail clients (such as Foxmail, outlook, etc.) can only meet the scenario of sending the same mail to multiple mail recipients (main feed & carbon feed & close feed). The scenario of "mail requiring batch, peer-to-peer, sending different content to different persons" is not supported.
Disclosure of Invention
The invention aims to solve the technical problems in the prior art and provides an email distribution method, an email distribution system, an email distribution medium and email distribution equipment.
In order to solve the above technical problems, an embodiment of the present invention provides an email distribution method, including:
receiving mail parameter configuration information filled in a sheet page of Excel, and generating mails with corresponding contents according to the mail parameter configuration information;
when receiving the mail sending trigger information, circularly calling a corresponding mail server according to the mail parameter configuration information to carry out mail distribution.
In order to solve the above technical problem, an embodiment of the present invention further provides an email distribution system, including:
the parameter configuration module is used for receiving mail parameter configuration information filled in a sheet page of Excel and generating mails with corresponding contents according to the mail parameter configuration information;
and the mail distribution module is used for circularly calling a corresponding mail server to distribute the mails according to the mail parameter configuration information when receiving the mail sending trigger information.
To solve the above technical problem, an embodiment of the present invention further provides a computer readable storage medium, including instructions, which when executed on a computer, cause the computer to execute the email distribution method according to the above technical solution.
In order to solve the above technical problems, an embodiment of the present invention further provides a computer device, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor implements the email distribution method according to the above technical scheme when executing the program.
The beneficial effects of the invention are as follows: according to the invention, through the mail parameter configuration information filled in the sheet page of Excel, different recipients and different mail contents can be configured; when receiving the mail sending trigger information, circularly calling a corresponding mail server according to the mail parameter configuration information to distribute the mail. The invention simplifies the complicated batch operation by automatic execution, realizes batch and point-to-point mode for sending mails with different contents to different users, and can obtain expected results by clicking a mail sending button on an interface only by a certain configuration, thereby greatly improving the working efficiency; and the batch distribution logic does not cause instantaneous pressure on the mail server, so that the operation is more stable and reliable.
Additional aspects of the invention and advantages thereof will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the invention.
Drawings
Fig. 1 is a signaling interaction diagram of an email distribution method according to an embodiment of the present invention;
fig. 2 is a schematic block diagram of an email distribution system according to an embodiment of the present invention.
Detailed Description
The principles and features of the present invention are described below with reference to the drawings, the examples are illustrated for the purpose of illustrating the invention and are not to be construed as limiting the scope of the invention.
The embodiment of the invention is realized by using the programming language OLE Automation for executing the universal Automation task in Desktop Application developed based on Microsoft. Specifically, the latest Microsoft Excel is installed and macros are enabled in the settings. And the mail server sending the mail supports a simple mail transfer protocol (Simple Mail Transfer Protocol, SMTP).
Fig. 1 is a signaling interaction diagram of an email distribution method according to an embodiment of the present invention. As shown in fig. 1, the method includes: receiving mail parameter configuration information filled in a sheet page of Excel, and generating mails with corresponding contents according to the mail parameter configuration information; when receiving the mail sending trigger information, circularly calling a corresponding mail server according to the mail parameter configuration information to carry out mail distribution.
In the above embodiment, through the mail parameter configuration information filled in the sheet page of Excel, different recipients and different mail contents can be configured; when receiving the mail sending trigger information, circularly calling a corresponding mail server according to the mail parameter configuration information to distribute the mail. According to the mail distribution method provided by the embodiment of the invention, complicated batch operation is simplified through automatic execution, different mails with different contents are sent to different persons in a batch and point-to-point mode, a user only needs to perform certain configuration, and then clicks a mail sending button on an interface, so that an expected result can be obtained, and the working efficiency is greatly improved; and the batch distribution logic does not cause instantaneous pressure on the mail server, so that the operation is more stable and reliable. Only proper adjustment is needed, so that the requirements of different scenes can be met.
Optionally, in one embodiment, the user needs to complete the necessary parameter configuration before sending the mail. As shown in table 1, the mail parameter configuration information may include mail service information, sender information, a recipient list, a mail body corresponding to a recipient member in the recipient list, and the number of mails sent each time in the loop call process.
TABLE 1
As can be seen from table 1, the mail service information may include an SMTP service address, an STMP service port, a mail transmission account number, and a mail transmission password. The sender information includes a sender mailbox. The recipient list may include a recipient ID and/or a recipient name, as well as a recipient mailbox and mail delivery status.
The mail body may be explicitly associated with the addressee in the personnel list, namely: in the list level information to be transmitted, information capable of identifying the recipient member, such as the recipient name, personal ID, and the like, needs to be explicitly recorded.
Personnel key information can be parameterized in the mail text. The key information is different in different scenes. Such as:
scene 1: periodically, the manager sends monthly performance scores to the department staff point to point, wherein the key information comprises: name, assessment item score, total score;
scene 2: the administrative staff member sends digital version welfare, wherein the key information comprises: name, digital version welfare redemption code.
The key information is parameterized, namely, the key information is set as a parameter variable in the mail body, and the variable is assigned in the cyclic processing process to generate mail body information for different recipients.
The user clicks the "send mail" button to start sending mail automatically, and no action can be performed except by pressing the ESC to force the program to be suspended. After the mail is sent, a prompt of successful sending and time consuming is popped up. In the personnel list, the column of the mail sending status corresponding to each row records the mail sending success/failure information. In this embodiment, by recording the transmission status of each mail, tracking and tracing of mail transmission records can be achieved.
Optionally, in one embodiment, the generating the mail with the corresponding content according to the mail parameter configuration information includes: and generating corresponding mails according to different recipients in the recipient list and mail texts corresponding to the different recipients.
Optionally, in an embodiment, the circularly calling the corresponding mail server to perform mail distribution according to the mail parameter configuration information includes: and determining a corresponding mail server according to the mail service information, calling a corresponding number of threads according to the number of mails sent each time, and sending the generated mails to the mail server by utilizing the threads.
In this embodiment, the number of mails sent at a time can be configured as needed. And one mail can be sent each time in a circulating way, so that the influence on a mail server can be reduced to the minimum, and the operation is more stable.
Optionally, in an embodiment, the mail parameter configuration information further includes a mail type. In particular, the mail type may include plain text or HTML. In this embodiment, a plurality of mail body forms are provided, and the user can freely select as required.
In a specific work, the mail distribution method provided by the embodiment of the invention can realize the distribution of monthly performance assessment notification mails to department personnel and the distribution of welfare (electronic coupons) in the whole company range. Table 2 below is a coupon distribution arrangement table.
TABLE 2
With the above configuration, mail transmission can be achieved by the following table 3.
TABLE 3 Table 3
The list interface of the receiving mail personnel is shown in the following table 4.
TABLE 4 Table 4
As can be seen from Table 4, the addressee list may include a department name, employee type, amount, exchange code, etc., in addition to the addressee ID and/or addressee name, addressee mailbox and mail sending status.
In the above embodiment, the user performs necessary parameter configuration, and then clicks the "send mail" button on the interface, so that complicated batch operation can be simplified through automatic execution, and a batch and point-to-point mode is implemented to send mails with different contents to different persons, thereby greatly improving the working efficiency; and the batch distribution logic does not cause instantaneous pressure on the mail server, so that the operation is more stable and reliable. Only proper adjustment is needed, so that the requirements of different scenes can be met.
The email distribution method provided according to the embodiment of the present invention is described in detail above with reference to fig. 1. An email distribution system provided by an embodiment of the present invention is described in detail below with reference to fig. 2.
As shown in fig. 2, an embodiment of the present invention further provides an email distribution system, including:
the parameter configuration module is used for receiving mail parameter configuration information filled in a sheet page of Excel and generating mails with corresponding contents according to the mail parameter configuration information;
and the mail distribution module is used for circularly calling a corresponding mail server to distribute the mails according to the mail parameter configuration information when receiving the mail sending trigger information.
In the above embodiment, through the mail parameter configuration information filled in the sheet page of Excel, different recipients and different mail contents can be configured; when receiving the mail sending trigger information, circularly calling a corresponding mail server according to the mail parameter configuration information to distribute the mail. The invention can realize a batch and point-to-point mode for sending mails with different contents to different persons. The user only needs to perform certain configuration and then click a mail sending button on the interface, so that an expected result can be obtained, and the working efficiency is greatly improved.
The embodiment of the invention also provides a computer readable storage medium, which comprises instructions, wherein when the instructions run on a computer, the computer is caused to execute the email distribution method according to the embodiment.
The embodiment of the invention also provides a computer device, which comprises a memory, a processor and a computer program stored in the memory and capable of running on the processor, wherein the processor realizes the email distribution method according to the embodiment when executing the program.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the apparatus and units described above may refer to corresponding procedures in the foregoing method embodiments, which are not described herein again.
In the several embodiments provided in this application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of elements is merely a logical functional division, and there may be additional divisions of actual implementation, e.g., multiple elements or components may be combined or integrated into another system, or some features may be omitted, or not performed.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed over a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the embodiment of the present invention.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention is essentially or a part contributing to the prior art, or all or part of the technical solution may be embodied in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods of the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing description of the preferred embodiments of the invention is not intended to limit the invention to the precise form disclosed, and any such modifications, equivalents, and alternatives falling within the spirit and scope of the invention are intended to be included within the scope of the invention.

Claims (9)

1. An email distribution method, comprising:
receiving mail parameter configuration information filled in a sheet page of Excel, and generating mails with corresponding contents according to the mail parameter configuration information; the mail parameter configuration information comprises mail service information, sender information, a recipient list, mail texts corresponding to recipient members in the recipient list and the quantity of mails sent each time in a circular calling process;
when receiving the mail sending trigger information, circularly calling a corresponding mail server according to the mail parameter configuration information to carry out mail distribution.
2. The method according to claim 1, wherein the generating the mail of the corresponding content according to the mail parameter configuration information includes: and generating corresponding mails according to different recipients in the recipient list and mail texts corresponding to the different recipients.
3. The method according to claim 1, wherein the cyclically calling the corresponding mail server for mail distribution according to the mail parameter configuration information comprises:
and determining a corresponding mail server according to the mail service information, calling a corresponding number of threads according to the number of mails sent each time, and sending the generated mails to the mail server by utilizing the threads.
4. The method of claim 1, wherein the mail parameter configuration information further comprises mail type.
5. The method of claim 1, wherein the mail type comprises plain text or HTML.
6. The method of claim 1, wherein the recipient list includes a recipient ID and/or a recipient name, and further comprising a recipient mailbox and a mail delivery status.
7. An email distribution system, comprising:
the parameter configuration module is used for receiving mail parameter configuration information filled in a sheet page of Excel and generating mails with corresponding contents according to the mail parameter configuration information; the mail parameter configuration information comprises mail service information, sender information, a recipient list, mail texts corresponding to recipient members in the recipient list and the quantity of mails sent each time in a circular calling process;
and the mail distribution module is used for circularly calling a corresponding mail server to distribute the mails according to the mail parameter configuration information when receiving the mail sending trigger information.
8. A computer readable storage medium comprising instructions which, when run on a computer, cause the computer to perform the e-mail distribution method according to any of claims 1-6.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the email distribution method of any of claims 1-6 when the program is executed by the processor.
CN202010016607.4A 2020-01-08 2020-01-08 E-mail distribution method, system, medium and equipment Active CN111210203B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010016607.4A CN111210203B (en) 2020-01-08 2020-01-08 E-mail distribution method, system, medium and equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010016607.4A CN111210203B (en) 2020-01-08 2020-01-08 E-mail distribution method, system, medium and equipment

Publications (2)

Publication Number Publication Date
CN111210203A CN111210203A (en) 2020-05-29
CN111210203B true CN111210203B (en) 2023-08-08

Family

ID=70784166

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010016607.4A Active CN111210203B (en) 2020-01-08 2020-01-08 E-mail distribution method, system, medium and equipment

Country Status (1)

Country Link
CN (1) CN111210203B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110380951B (en) * 2019-06-13 2022-07-12 平安科技(深圳)有限公司 Method and device for sending e-mail
CN112819309A (en) * 2021-01-25 2021-05-18 江西五十铃汽车有限公司 Employee performance scoring and payroll calculation system based on EXCEL software
CN114157629A (en) * 2021-10-29 2022-03-08 中国建设银行股份有限公司 Mail distribution method, device, equipment and medium

Citations (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6226689B1 (en) * 1997-01-29 2001-05-01 Microsoft Corporation Method and mechanism for interprocess communication using client and server listening threads
KR20020092730A (en) * 2001-06-05 2002-12-12 주식회사 유텐드 group E-mailing system and method for transmit and receive of the same
TW200405969A (en) * 2002-05-30 2004-04-16 Sony Corp Information transmission/reception apparatus; apparatus and method of information transmission, reception, and processing; management apparatus and method of information transmission and reception; recording medium and program
JP2005011368A (en) * 2000-03-06 2005-01-13 Hiroaki Harada System and method for information distribution, distributing server device, and information distribution control program
JP2005284955A (en) * 2004-03-30 2005-10-13 Hitachi Software Eng Co Ltd Electronic mail transmitting/receiving system
CN1848172A (en) * 2005-04-12 2006-10-18 日本先锋公司 Information processing device, information processing system, and information processing method
JP2007199806A (en) * 2006-01-24 2007-08-09 Sony Corp Transmitter and transmission method, receiver and reception method, distribution server and distribution method, and program
JP2007257076A (en) * 2006-03-20 2007-10-04 Fujitsu Ltd Device and method for transmitting/receiving e-mail with comment
CN101547165A (en) * 2008-03-28 2009-09-30 国际商业机器公司 Method for sending and distributing e-mails and e-mail servers
CN103812838A (en) * 2012-11-13 2014-05-21 中国移动通信集团公司 Service calling method and device and system
CN105847131A (en) * 2016-05-12 2016-08-10 广东万丈金数信息技术股份有限公司 Mail sending method and system, mail sending server and mail receiving server
CN106921557A (en) * 2015-12-25 2017-07-04 阿里巴巴集团控股有限公司 A kind of e-mail sending method and equipment
CN109447472A (en) * 2018-10-30 2019-03-08 平安科技(深圳)有限公司 Performance task data processing method, device, computer equipment and storage medium
CN109495380A (en) * 2019-01-07 2019-03-19 平安科技(深圳)有限公司 E-mail sending method, device, computer equipment and storage medium
CN109905319A (en) * 2019-04-19 2019-06-18 北京悦畅科技有限公司 A kind of generation method and device of mail data

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7155487B2 (en) * 2000-11-30 2006-12-26 Intel Corporation Method, system and article of manufacture for data distribution over a network
US7660861B2 (en) * 2005-06-21 2010-02-09 Data Laboratory, L.L.C. System and method for verifying the identity of a sender of electronic mail and preventing unsolicited bulk email
US8285651B1 (en) * 2005-12-30 2012-10-09 Stamps.Com Inc. High speed printing
CN102624649B (en) * 2012-03-22 2014-12-10 华为技术有限公司 Method, equipment and system for attaching E-mail attachment

Patent Citations (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6226689B1 (en) * 1997-01-29 2001-05-01 Microsoft Corporation Method and mechanism for interprocess communication using client and server listening threads
JP2005011368A (en) * 2000-03-06 2005-01-13 Hiroaki Harada System and method for information distribution, distributing server device, and information distribution control program
KR20020092730A (en) * 2001-06-05 2002-12-12 주식회사 유텐드 group E-mailing system and method for transmit and receive of the same
TW200405969A (en) * 2002-05-30 2004-04-16 Sony Corp Information transmission/reception apparatus; apparatus and method of information transmission, reception, and processing; management apparatus and method of information transmission and reception; recording medium and program
JP2005284955A (en) * 2004-03-30 2005-10-13 Hitachi Software Eng Co Ltd Electronic mail transmitting/receiving system
CN1848172A (en) * 2005-04-12 2006-10-18 日本先锋公司 Information processing device, information processing system, and information processing method
JP2007199806A (en) * 2006-01-24 2007-08-09 Sony Corp Transmitter and transmission method, receiver and reception method, distribution server and distribution method, and program
JP2007257076A (en) * 2006-03-20 2007-10-04 Fujitsu Ltd Device and method for transmitting/receiving e-mail with comment
CN101547165A (en) * 2008-03-28 2009-09-30 国际商业机器公司 Method for sending and distributing e-mails and e-mail servers
CN103812838A (en) * 2012-11-13 2014-05-21 中国移动通信集团公司 Service calling method and device and system
CN106921557A (en) * 2015-12-25 2017-07-04 阿里巴巴集团控股有限公司 A kind of e-mail sending method and equipment
CN105847131A (en) * 2016-05-12 2016-08-10 广东万丈金数信息技术股份有限公司 Mail sending method and system, mail sending server and mail receiving server
CN109447472A (en) * 2018-10-30 2019-03-08 平安科技(深圳)有限公司 Performance task data processing method, device, computer equipment and storage medium
CN109495380A (en) * 2019-01-07 2019-03-19 平安科技(深圳)有限公司 E-mail sending method, device, computer equipment and storage medium
CN109905319A (en) * 2019-04-19 2019-06-18 北京悦畅科技有限公司 A kind of generation method and device of mail data

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
面向企业应用的分布式电子邮件收发管理系统;郭蕴华,陈定方;交通与计算机(第05期);第57-59页 *

Also Published As

Publication number Publication date
CN111210203A (en) 2020-05-29

Similar Documents

Publication Publication Date Title
CN111210203B (en) E-mail distribution method, system, medium and equipment
US6704772B1 (en) Thread based email
US10673797B2 (en) Message categorization
US10185479B2 (en) Declassifying of suspicious messages
US8935342B2 (en) Method for detecting and unsubscribing an address from a series of subscriptions
US7343394B2 (en) Method of managing e-mail messages
US8321512B2 (en) Method and software product for identifying unsolicited emails
US7509382B1 (en) System and method to deflect email threads to a blogging system
US6823368B1 (en) Method and system for E-mail sender chain history by adding a sender-chain filed to the E-mail header when forwarding a chain forwarded E-mail message to another recipient
US9716685B2 (en) Cautious auto-entry for messaging systems
US8838718B2 (en) Virtual email method for preventing delivery of undesired electronic messages
EP2271036A1 (en) Method, system and architecture for delivering messages in a network to automatically increase a signal-to-noise ratio of user interests
US20070180031A1 (en) Email Opt-out Enforcement
US20100287246A1 (en) System for processing electronic mail messages with specially encoded addresses
JP2006521635A5 (en)
AU2009299539B2 (en) Electronic communication control
US20170118149A1 (en) Deduplication of e-mail content by an e-mail server
US10764220B1 (en) Message abuse sender feedback loop
US7870208B2 (en) Dynamic reader-instigated categorization and distribution restriction of mailing list threads
CN112785353B (en) Method for adding vermicelli to sales WeChat in guiding way
CN1696949A (en) Method of anti garbage E-Mails for receiving/transmitting server, and system of anti garbage E-mails
EP2127274A2 (en) System, method and program for managing e-mail
US20060294188A1 (en) Providing status information about email recipients
McElligott A Security pass for messages: message keys
CN107835124B (en) Mail sending method, device and system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant