将电子邮件附件提取到MS数据库中 [英] Extract Email Attachment into MS database
问题描述
我正在开发MS Access 2016中的简单任务监控工具。我已将outlook收件箱链接到我的访问数据库中。但我只是得到文本，我正在寻找如何从电子邮件到数据库的附件。
是否可以通过vba执行此操作？我写了这段代码，但它没有按预期工作。任何帮助将不胜感激。
I am working on simple task monitoring tool build in MS Access 2016. I have link the outlook inbox into my access db. but I am only getting text, I am looking hit how I could get attachment from the emails into the db as well.
Is it possible to do this through vba? I have wrote this code but its not working as intended. Any help will be greatly appreciated.
推荐答案
Adict：
无法正常工作
Adict:
not working as intended
不确定是''如果我是诚实的，那将非常有帮助。
请记住，我们不是在你的电脑上，而是只有你告诉我们进去的东西。所以，不会那么多。 br />
会发生什么？它在哪里打破？它是如何破坏的？
Not sure that''s very helpful if I''m honest.
Bear in mind we aren''t at your computer and only have what you tell us to go in. So, not much then.
What happens? Where does it break? How does it break?
所以上面的代码运行良好，但它查看outlook文件夹中的所有电子邮件并提取电子邮件，我需要的是像收到的每封电子邮件都注册到我的内部表名为Inbox，其中包含该单个电子邮件的其余文本和附件。搜索很多，但没有碰到任何。感谢我是否可以指向正确的方向
So the code above runs well but its looking at all the emails in the outlook folder and extracting emails, what i need is something like every email received gets registered into my internal table called Inbox with the rest of the text and attachment from that single email. Search much but didn''t come across any . appreciate if i can be pointed to right direction
Adict，
1）很少将文件存储在访问数据库中。数据库的文件大小相当小，而且膨胀是可怕的。
2）你的代码中没有对数据库的引用。
3）你的后续工作仍然有点模糊，也许这是我所拥有的最后一小时/漫长的一天？
也许，试着一步一步地解释你想要什么时尚？
4）您是从Outlook还是从Access运行此代码？
Adict,
1) Rarely a good idea to store files in an access database. The file size of the database is fairly small and the bloat is horrendous.
2) You have no reference to the database in your code.
3) Your follow-up is still a bit obscure, maybe it''s the late hour/long day I have had?
Perhaps, try to explain what you want in a step by step fashion?
4) Are you running this code from Outlook or from Access?
这篇关于将电子邮件附件提取到MS数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
