Consulting

Results 1 to 2 of 2

Thread: Linking Outlook VBA to Excel

  1. #1
    VBAX Newbie
    Joined
    Oct 2018
    Posts
    1
    Location

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

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    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
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •