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 testoutlookproblem.jpg