a1003520
10-18-2018, 07:00 AM
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 test23061
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 test23061