#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Cross-posted at: http://www.vbaexpress.com/forum/show...k-VBA-to-Excel
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
outlook 2013, template form, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
250 Excel Tips link | cannetom | Excel | 2 | 01-18-2016 09:25 AM |
Excel Link in word | chandan56 | Office | 3 | 07-02-2015 07:07 PM |
link excel into word | Rolsen | Word | 2 | 11-19-2014 03:36 PM |
Link Excel and OneNote | swatkat | Excel | 0 | 09-17-2014 12:32 PM |
Link Excel and OneNote | swatkat | OneNote | 0 | 09-17-2014 10:59 AM |