将Outlook VBA链接到EXCEL [英] Linking Outlook VBA to EXCEL

问题描述

Hello Everyone

Hello Everyone

我正在开展一个项目。我需要构建一个自定义模板，我需要发送给人们填写填写并返回表单

I am working on a project now. I need to build a custom template outform which I need to send for people to fill fill in and return the form

但是，我的要求是填充一些字段，例如excel列中的ABM名称，这是一个下拉列表

However, my requirement is to populate some fields e.g ABM Name from an excel column, which is a dropdown list

此外，频道与ABM名称相关。如果我选择ABM名称，它会自动填充频道。

Also the Channel is related to the ABM name. In that if I select ABM Name, it automatically populate the Channel.

在Excel工作表中，示例如下：

In the excel sheet, the example is like:

ABN姓名         频道

ABN Name         Channel

John                 营销

John                 Marketing

Joe                   销售

Joe                   Sales

与位于另一个Excel文件中的产品代码和产品描述相同

现在：

1。如何连接excel文件以在Outlook VBA中运行

1. How do I connect the excel file to run in outlook VBA

2。我如何编码VBA，例如提供ABN名称是excel 到comboxbox框中的ABN

2. How do i code the VBA e.g to feed the ABN Name is excel  to ABN in the comboxbox box

3。如果有人可以帮我提供我可以测试的示例代码，将会很感激

3. It will be appreciative if someone can help me with a sample code which I can test

我会附上图片

推荐答案

Hi，

Hi,

这是讨论Microsoft Excel功能的问题和反馈的论坛，我将把你的问题转移到MSDN的Excel论坛上

This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们建议适当发布的原因是您将获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。谢谢为了你的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

问候，

Emi

Emi

这篇关于将Outlook VBA链接到EXCEL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！