链接到Exchange服务器上的Outlook [英] Linking to outlook across an exchange server
问题描述
您好，
论坛的新手，但阅读了很多文章，这些文章帮助我完成了开发vba应用程序的工作。
我有点陷入困境，所以我想我会注册并提出问题。我创建了一个链接到交换服务器上的oulook邮箱的应用程序。
我之前用自己的收件箱设置了它（在交换服务器上也是如此）基本上应用程序的这一部分所做的是提供链接的收件箱的表单视图，然后在按钮单击事件上，它将当前电子邮件添加到具有主键和辅助键的表中。
我的问题不是如何让它工作，因为我已经用我自己的收件箱成功管理了它，但现在我创建了一个新的收件箱，它对几个人有共同的所有权，一切似乎工作正常，除了电子邮件将不再添加到表。它没有抛出异常但是当我检查表时它没有添加记录。
当我重新链接到我自己的收件箱时，一切都开始正常工作，我真的很难过。我显然拥有共享收件箱的所有权，所以我不认为权限是一个问题。
我也注意到我可以使用共享收件箱中的信息运行追加查询，它只是它不喜欢它使用表格！
我已经在下面发布了我的代码，用于这个特定的程序：
很多谢谢
Ben
Hi There,
New to the forum but read many an article which have helped me no end in developing vba applications.
I''m a tad stuck though so i thought i''d register and ask the question. I have created an application that links to a oulook mailbox which is held on theexchange server.
I had previously set it up with my own inbox (on the exchange server as well) and basically what this part of the application does is give a form view of the inbox which is linked and then on a button click event it adds the current email to a table with a primary and secondary key.
My question is not how to get it to work as i have successfully managed that with my own inbox, but now i have had a new inbox created which has a shared ownership over several people, everything seems to be working fine except the emails will no longer add to the table. It doesn''t throw an exception but when i check the table it hasn''t added the record.
I am really scratching my head as when I re-link to my own inbox everything starts working again fine. I aparently have ownership of the shared inbox so i don''t think permissions is a problem.
I have also noticed that i can run an append query using information from the shared inbox fine, its just it doesn''t like it using the form!
I have posted my code below for this specific procedure:
Many Thanks
Ben
推荐答案
Ben，
首先欢迎来到TSDN :)
至于你的问题我会分享我的想法，但他们可能不会太有帮助，因为我在这方面的经验（交换/展望）非常有限。
在我看来，因为它适用于你邮箱但不是另一个，这里可能有以下两个问题之一：
Ben,
Firstly welcome to TSDN :)
As far as your problem goes I will share my thoughts but they may not be too helpful as my experience in this area (Exchange/Outlook) is quite limited.
It seems to me though, from the fact that it works for your mailbox but not for the other, that there may be one of two issues showing here :
- 代码中的某些内容专门指向您的邮箱。不太可能。我检查了你的代码，虽然不是每个可能的项目都可见（一些来自数据），但我没有看到任何可能支持这一点。
- Exchange邮箱的一些权限问题。我假设您已尝试使用Outlook（或类似客户端）从同一台计算机访问其他邮箱。
即使您有，但这并不排除这是问题，因为Exchange上的权限可以复杂而灵活。
这些只是我的想法。我看不出有什么明显的原因可能会出现这种情况。
These are just my thoughts. I can''t see any clear reason why this might be behaving this way.
感谢您的回复和欢迎：D NeoPa，
我以为它可能是我的代码中的某个地方专门链接到邮箱，但我与outlook的连接只是指table_inbox，我只是将我的收件箱中的连接更改为共享（跟踪器）收件箱，它依赖'在完全相同的字段（来自，主题，收到的日期和内容）。它真的让我感到困惑，因为我可以很好地查看电子邮件，我可以通过自己输入参数手动查询它，但不幸的是我需要自动链接电子邮件，因为它是一个呼叫记录系统。我可以在outlook中查看收件箱并发送和接收电子邮件。
我能想到的唯一其他选项是每次打开收件箱时都会在收件箱中运行导入查询以查找电子邮件它还没有，但这很麻烦，因为并不是所有的电子邮件都需要连接到一个电话。
我想下一步就是问IT老师有什么权限在帐户上设置了，但是因为我被安排了所有者，我会认为我无论如何都拥有所有权利。
非常感谢
Ben
Thanks for the response, and the welcome :D NeoPa,
I had thought it might be that somewhere in my code that it links specifically to a mailbox, but my connection to outlook simply refers to table_inbox where i just changed the connection from my inbox to the shared (tracker) inbox, it rely''s on exactly the same fields (from, subject, received date & contents). It really has me perplexed as I can view the emails fine, I can manually query it by entering parameters myself, but unfortunately I need to link emails automatically as it is a call logging system. I can view the inbox in outlook and send and receive emails fine.
The only other option i can think of is to run an import query on the inbox every time it opens to find emails it doesn''t have yet, but that is cumbersome as not all emails will neccessarily be needed to linked to a call.
I guess next step is to ask the IT guys what permissions were set up on the account, but as I have been placed owner i would assume I had all rights anyhow.
Many Thanks
Ben
Ben，
首先欢迎来到TSDN :)
目前为止当你的问题出现时，我会分享我的想法，但他们可能不会太有帮助，因为我在这方面的经验（Exchange / Outlook）非常有限。
在我看来，从它的事实来看适用于您的邮箱但不适用于其他邮箱，可能会出现以下两个问题之一：
Ben,
Firstly welcome to TSDN :)
As far as your problem goes I will share my thoughts but they may not be too helpful as my experience in this area (Exchange/Outlook) is quite limited.
It seems to me though, from the fact that it works for your mailbox but not for the other, that there may be one of two issues showing here :
- 代码中的某些内容专门指向您的邮箱。不太可能。我检查了你的代码，虽然不是每个可能的项目都可见（一些来自数据），但我没有看到任何可能支持这一点。
- Exchange邮箱的一些权限问题。我假设您已尝试使用Outlook（或类似客户端）从同一台计算机访问其他邮箱。
即使您有，但这并不排除这是问题，因为Exchange上的权限可以复杂而灵活。
这些只是我的想法。我看不出有什么明显的原因可能会出现这种情况。
These are just my thoughts. I can''t see any clear reason why this might be behaving this way.
你好，
论坛新用户但阅读了很多文章，这些文章帮助我完成了开发vba应用程序的工作。
我虽然陷入困境，所以我想我会注册并提出问题。我创建了一个链接到交换服务器上的oulook邮箱的应用程序。
我之前用自己的收件箱设置了它（在交换服务器上也是如此）基本上应用程序的这一部分所做的是提供链接的收件箱的表单视图，然后在按钮单击事件上，它将当前电子邮件添加到具有主键和辅助键的表中。
我的问题不是如何让它工作，因为我已经用我自己的收件箱成功管理了它，但现在我创建了一个新的收件箱，它对几个人有共同的所有权，一切似乎工作正常，除了电子邮件将不再添加到表。它没有抛出异常但是当我检查表时它没有添加记录。
当我重新链接到我自己的收件箱时，一切都开始正常工作，我真的很难过。我显然拥有共享收件箱的所有权，所以我不认为权限是一个问题。
我也注意到我可以使用共享收件箱中的信息运行追加查询，它只是它不喜欢它使用表格！
我已经在下面发布了我的代码，用于这个特定的程序：
很多谢谢
Ben
Hi There,
New to the forum but read many an article which have helped me no end in developing vba applications.
I''m a tad stuck though so i thought i''d register and ask the question. I have created an application that links to a oulook mailbox which is held on theexchange server.
I had previously set it up with my own inbox (on the exchange server as well) and basically what this part of the application does is give a form view of the inbox which is linked and then on a button click event it adds the current email to a table with a primary and secondary key.
My question is not how to get it to work as i have successfully managed that with my own inbox, but now i have had a new inbox created which has a shared ownership over several people, everything seems to be working fine except the emails will no longer add to the table. It doesn''t throw an exception but when i check the table it hasn''t added the record.
I am really scratching my head as when I re-link to my own inbox everything starts working again fine. I aparently have ownership of the shared inbox so i don''t think permissions is a problem.
I have also noticed that i can run an append query using information from the shared inbox fine, its just it doesn''t like it using the form!
I have posted my code below for this specific procedure:
Many Thanks
Ben
这篇关于链接到Exchange服务器上的Outlook的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
