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

outlookproblem.png (75.8 KB, 14 views)