如何使用 SQL Server 数据库访问 Gmail 以存储在自定义 CRM 中？
我有一位客户希望他定制的 CRM 能够访问销售人员的电子邮件，以便有效地将客户和销售人员之间的电子邮件对话历史记录存储在 CRM 的数据库中。
CRM 是用 Visual Basic 2008 编写的，数据库是SQL Server 2008。这些人在商店和路上使用的唯一电子邮件是 Gmail。每个销售人员都有自己的 Gmail 地址。他们就是这样运作的。
如果他们在路上回复客户有关产品的电子邮件询问，他们希望将该电子邮件对话存储在数据库的表中。我认为这是我无法理解的部分。如何从 Visual Basic 2008 访问电子邮件数据（知道用户 ID 和密码）？
免费或接近免费的解决方案将是首选。
I have a client who wants his custom-written CRM to be able to access his sales people's emails so that, effectively, a history of email conversations between customer and salesperson is stored inside the CRM's database.
The CRM is written in Visual Basic 2008 and the database is SQL Server 2008. The only email these people use, in the shop and on the road, is Gmail. Each sales person has their own Gmail address. That's how they operate.
If they're on the road and respond to a customer's email inquiry about a product, they would like that email conversation to be stored in a table in the database. I think that's the part I can't wrap my head around. How do I get access to the email data (knowing the user id and password) and doing so from Visual Basic 2008?
A free or close to free solution would be preferred.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我们过去做过的一件事是创建一个单独的电子邮件帐户，然后让用户密件抄送此电子邮件地址，例如 [电子邮件受保护]。然后，我们在服务器上有一个小型应用程序，它从该中央邮箱轮询电子邮件，并根据收件人电子邮件地址自动将其附加到实体。
我们还允许用户在电子邮件底部添加一些命令，用于附加到工作订单和/或账单等内容，例如 wo 1000（对于工作订单 1000）或 b 1000（对于账单 1000）。
只是另一个想法。
One thing that we have done in the past is create a separate email account and just have the users to BCC this email address, for example, [email protected]. We then have a small application, on the server, that polls email from this central mailbox and automatically attaches it to the entity based on the recipients email address.
We also allow the user to add some commands at the bottom of the email, for attaching to things like work orders and/or bills, for example, wo 1000 (for a work order 1000) or b 1000 (for bill 1000).
Just another idea.