通过导入Excel工作表自动发送电子邮件 [英] Automatic Email Sending by Importing an Excel sheet

问题描述

亲爱的极客，

我目前正在分析以构建自动电子邮件调度系统.

目标:开发一个自动电子邮件系统，该系统将从导入的excel工作表中获取电子邮件ID和文本，并将电子邮件发送给excel工作表中的所有成员.

首选语言:C#.NET 3.0，ASP.NET 3.0或Java脚本.

说明:
最初是一个接口，用于指定要上传的excel工作表，并配置了本地SMTP/POP3服务器或Exchange服务器(可能是电子邮件服务).
成功完成上传和身份验证后，它应该将邮件发送到excel工作表中提到的所有成员名称.
如果一个单元格留空，则应切换到下一个单元格.

发送电子邮件的预期平均速度:30-45电子邮件/小时.

建议为该应用程序提供更强大的功能.
谢谢.

Dear Geeks,

I am currently analyzing to build an Automated Email Dispatching system.

Objective : To develop an automated email system which fetches the email id and the text from the imported excel sheet and dispatches emails to all the members in the excel sheet.

Language Preferred : C#.NET 3.0, ASP.NET 3.0 or Java Script.

Description:
Initially an interface which would specify the to upload the excel sheet and configured with local SMTP/POP3 Server or an Exchange Server, what ever may be the email service.
After the successful uploading and authentication is done,it should sending the mails to all the members name mentioned in the excel sheet.
In case if a cell is left blank,it should switch to the next cell.

Expected Avg Speed for sending the email: 30-45 Emails/hr.

Suggest for more robustness for the app.
Thank you.

Techie.

推荐答案

开发Windows服务或Windows应用程序并将其安排在其上.

Develop a windows service ,or a windows application and put schedular onto it.

这取决于要求，您是否真的要让任何用户都将名称和emailid的excel加载到您的服务器，然后该应用程序应该邮寄到该应用程序中存在的所有条目，那么可能是Web应用程序是解决方案，但是如果您是该应用程序的唯一用户，您知道excel文件的位置，那么我可能还建议创建一个Windows服务，该服务可以为您做同样的事情，而且完全不需要您的干预.

如果您认为答案有帮助，请投票.

It depends on the requirement, do you really want any user to load an excel of names and emailid to your server and then the application should mail to all entries present in the application, then probably web application is the solution but if you are the only user to the app and you know the excel files location, then probably I would also suggest to create a windows service that can do the same for you and it will not require your intervention at all.

Please vote if you think the answer helped you.

这篇关于通过导入Excel工作表自动发送电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！