Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-02-2018, 08:29 AM
emillerd's Avatar
emillerd emillerd is offline How to get address from excel based on variable typed into word. Windows 7 64bit How to get address from excel based on variable typed into word. Office 2016
Novice
How to get address from excel based on variable typed into word.
 
Join Date: Apr 2018
Posts: 2
emillerd is on a distinguished road
Default How to get address from excel based on variable typed into word.

I did a search of the forum but am not really what to call this.
What I am trying to do is type a number into word and have it bring in address from excel. Ie: I type in 18003 and it looks to a excel sheet for that number and returns
XYZ Corp
1212 Boogie Boogie Ave
Any Town, NY 15666



and places it into the word table cell.

I'm not sure this is possible, but it seems like it should be. This wouldn't be a mail merge type thing as I would like to use it elsewhere in the document for different information too.

Any ideas on how to do this or has anyone heard of this and can point me in the direction of a tutorial?

Thank you!
Reply With Quote
  #2  
Old 04-02-2018, 11:14 AM
Charles Kenyon Charles Kenyon is offline How to get address from excel based on variable typed into word. Windows 10 How to get address from excel based on variable typed into word. Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

The best way is nevertheless, Mail Merge.

It is for far more than mailings.
You would have one column with your key numbers. The rest of the row for each number would contain the data you want.

That is the quickest and simplest way to reference data in an Excel spreadsheet while in Word.
Reply With Quote
  #3  
Old 04-02-2018, 11:36 AM
emillerd's Avatar
emillerd emillerd is offline How to get address from excel based on variable typed into word. Windows 7 64bit How to get address from excel based on variable typed into word. Office 2016
Novice
How to get address from excel based on variable typed into word.
 
Join Date: Apr 2018
Posts: 2
emillerd is on a distinguished road
Default

Thank you Charles. I will give it a try and see how well I do.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get address from excel based on variable typed into word. Embed a map into a word document based on an address? ayupchap Mail Merge 3 09-18-2017 01:43 PM
word document as web page no print out for typed answers widescreenforever Word 2 10-19-2016 03:40 PM
How to get address from excel based on variable typed into word. Filling the rest of the document with a word only typed once. JakeLRL Word VBA 5 04-08-2016 07:56 AM
How to get address from excel based on variable typed into word. Variable text field code based on occurrences on each page Cosmo Word 2 12-29-2015 11:54 AM
Variable / Conditional Address in Chart Data SteveBump Excel 7 02-07-2014 05:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:56 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