Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2018, 05:46 AM
a1003520 a1003520 is offline Outlook VBA link to Excel Windows 10 Outlook VBA link to Excel Office 2013
Novice
Outlook VBA link to Excel
 
Join Date: Oct 2018
Posts: 1
a1003520 is on a distinguished road
Default 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
Attached Images
File Type: png outlookproblem.png (75.8 KB, 12 views)
Reply With Quote
  #2  
Old 10-18-2018, 01:09 PM
macropod's Avatar
macropod macropod is offline Outlook VBA link to Excel Windows 7 64bit Outlook VBA link to Excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Tags
outlook 2013, template form, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
250 Excel Tips link cannetom Excel 2 01-18-2016 09:25 AM
Outlook VBA link to Excel Excel Link in word chandan56 Office 3 07-02-2015 07:07 PM
Outlook VBA link to Excel 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft