Linking Outlook VBA 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 testAttachment 23061

Cross-posted at: http://www.msofficeforums.com/outloo...ink-excel.html
Please read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq...._new_faq_item3