View Single Post
 
Old 10-18-2018, 05:46 AM
a1003520 a1003520 is offline Windows 10 Office 2013
Novice
 
Join Date: Oct 2018
Posts: 1
a1003520 is on a distinguished road
Default Outlook VBA link to Excel

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

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

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

In the excel sheet, the example is like:



ABN Name Channel

John Marketing

Joe Sales

Same with Product Code and Product Description which reside in another excel file

Now:

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

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

3. It will be appreciative if someone can help me with a sample code which I can test
Attached Images
File Type: png outlookproblem.png (75.8 KB, 12 views)
Reply With Quote