将Outlook电子邮件拖放到Access DB [英] Drag and Drop Outlook Email to Access DB

问题描述

我尝试合并一些我在网上找到的代码。当我尝试将电子邮件保存到Access时，我一直收到运行时错误287。提前感谢任何建议。

I tried to incorporate some code I found online. I keep getting runtime error 287 when I attempt to save the email to Access. Thanks in advance for any advice.

展开 | 选择 | Wrap | 行号

推荐答案

就这样它没有''听起来你只是要求我们为你做你的工作，我可以建议你：

Just so it doesn''t sound like you''re simply asking us to do your work for you, may I suggest you :

1. 做一些dubugging（在VBA中进行调试）首先查看您的问题并找出发生了什么以及在哪里。
2. 描述代码正在做和期望做的事情，正如您所期望的那样如果有人要求您提供帮助。
3. 查找并发布错误消息287。
4. 确定引发错误的位置并按行号识别。

1. Do some dubugging (Debugging in VBA) on your problem first and find out what''s going on and where.
2. Describe what the code''s doing and expected to do, as you''d expect if someone were asking you for help.
3. Find and post the error message that goes along with error 287.
4. Determine where the error is thrown and identify that by line number.

经过一百多个帖子后，我承认有点惊讶，我不得不花点时间解释一些发布问题的基础知识。

After more than one hundred posts I admit to being a little surprised I have to take time to explain some of the basics of posting questions.

我试过调试和代码总是在第69行抛出应用程序定义的运行时错误287

" olSel.Item（1）.SaveAs strPathAndFile，olMSG"


我要对代码执行的操作是将Outlook电子邮件粘贴到备注字段，然后将电子邮件保存到文件中。抱歉发布所有代码。我只是觉得最好不要太多而不是太多。顺便说一下，代码最初是用于文本框的On Dirty事件。我尝试使用命令按钮执行代码，因为On Dirty当我将电子邮件粘贴到文本框时，事件未触发。感谢您的任何建议。

I tried debugging and the code always throws "application defined runtime error 287 at line 69

"olSel.Item(1).SaveAs strPathAndFile, olMSG"

What I am trying to do with the code is paste an outlook email to a memo field and then save the email to file. Sorry about posting all the code. I just thought it might be best to have too much than too little. By the way, the code was originally for the On Dirty event of the text box. I tried to use a command button to execute the code since the "On Dirty" event was not firing when I pasted an email to the textbox. Thanks for any advice.

我真正想要做的是将Outlook电子邮件复制并粘贴到Access中的表单，并通过Access将电子邮件保存到.msg文件。我不是贴在发布的代码上。如果有更简单的方法，我会更喜欢它。有没有人有过这种过程的经验？预先感谢您的任何帮助/建议。

what I really want to do is copy and paste an Outlook email to a form in Access and save the email to a .msg file via Access. I am not wed to the code posted. I would really like it better if there were an easier way of doing it. Does anyone have any experience with such a process? Thanks in advance for any help/advice.

这篇关于将Outlook电子邮件拖放到Access DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！