将附件位置保存到Access表 - 文件路径代码？ [英] Saving attachment location to Access table - filepath code?
问题描述
我有一些代码可以将电子邮件保存到数据库中，为新发件人创建新文件夹等等，但我现在要做的是当新电子邮件进来时，我希望将任何附件保存到表格中（通过保存位置，然后有能力返回并从该位置打开它）...我真正需要的是将显示文件路径的代码...有谁知道如何做到这一点？任何回复都表示赞赏。
I have some code which saves emails into a database, creates new folders for new senders etc etc but what I now want to do is when a new email comes in, i want any attachments to be saved into a table (by saving the location and then having the ability to go back in and open it from that location)... All I really need is the code which will show the filepath... does anybody know how to do this? Any replies appreciated.
推荐答案
丽贝卡，我们不提供代码。我们回答问题，在这种情况下几乎不可能，因为您在问题中包含的信息很少。你在忙什么？你有什么我们甚至可以开始的？
Rebecca, we don''t provide code. We answer questions, which in this case is next to impossible as you include so little information in your question. What are you working with? What do you have already that we can even start with?
当我找不到它/自己解决时，人们经常会帮助我编写代码。我没有放任何代码的原因是因为我认为这是非常直接的。我说过我已经为outlook自动化编写了一些代码。这是我的代码的摘录，因为整个模块很长。正如我所说的，我还要附加附加路径的表格。
Well people often help me with code when I can''t find it/work it out myself. The reason why I didn''t put any code was because I thought it was quite straight forwards. I did say I have already written some code for outlook automation. Here is an extract from my code as the entire module is quite long. As I said, I want to also append the table with the attachment path.
Rebecca McCallan：
当我找不到/自己解决问题时，人们经常会帮我处理代码。
Rebecca McCallan:
Well people often help me with code when I can''t find it/work it out myself.
专家可以自行决定提供代码，他们认为有助于说明他们想要表达的观点。他们也可以使用OP来生成代码，因为他们觉得OP并不是简单地要求为他们完成代码。我们不鼓励我们的专家在没有任何此类指示的情况下提供代码解决方案，因为它让成员们错误地理解我们在这里只是为他们提供解决方案 - 这不是我们的兴趣所在。我们的目标是帮助人们理解和学习。
显然，从你上一篇文章中，你已经有了一些代码并且很好地参与了这个项目，所以我很高兴认为你是在这种情况下我将与之合作的人，但请在未来的问题中牢记这一点。只是在问题中明确表示你不仅仅是要求为你完成你的工作，这将有助于事情变得更加顺利。
正如我所说，你的帖子在这一点上满足我。仍然缺少什么，对我来说，对工作环境有足够的了解是绝对必要的，这是我的第二个问题的答案 - 你们已经拥有了什么，我们甚至可以开始？
我正在寻找能够指出文件路径是什么的东西，或者从程序的角度来看它是如何产生的。可能与 MailObject 相关。我假设你还有一个字段名称，用于存储 rstSupportRequest 中路径的位置？
我怀疑解决方案将更多地与Outlook相关而不是访问一个，所以我可能不得不为你做一些挖掘，因为我不是Outlook专家，但是当你提供所要求的信息时我们会试一试。
An expert, at their discretion, can supply code where they feel it is helpful to illustrate a point they are trying to make. They can also work with an OP to produce code when they are comfortable that the OP is not simply asking for it to be done for them. We don''t encourage our experts to give code solutions without any such indication, as it leaves members with the mistaken understanding that we are here simply to provide solutions for them - which is not our interest. We aim to help people understand and learn.
Clearly, from your last post, you have some code already and are well into this project, so I''m happy to treat you as someone who I will be working with in this case, but please bear this in mind in future questions. Just something in the question to make it obvious you''re not simply asking for your work to be done for you, will help things go more smoothly.
As I say, your post satisfies me on that point. What is still missing, and absolutely necessary for me to have a good enough understanding of what the working environment is, is the answer to my second question - What do you have already that we can even start with?
I''m looking for something that indicates what the filepath is, or how it''s worked out from your program''s perspective. Maybe related to MailObject. I assume you also have a field name for where the path is stored within rstSupportRequest?
I suspect the solution will be more of an Outlook related one than an Access one, so I may have to do some digging for you as I''m no Outlook expert, but we''ll give it a try when you provide the requested info.
这篇关于将附件位置保存到Access表 - 文件路径代码？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
