Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2014, 03:40 PM
ElfegoBaca ElfegoBaca is offline Lookup table in word Windows 7 64bit Lookup table in word Office 2010 64bit
Novice
Lookup table in word
 
Join Date: May 2011
Posts: 5
ElfegoBaca is on a distinguished road
Default Lookup table in word

I would like to create a table in an Excel document called "Members" with seven fields: Name, Addr1, Addr2, City, State, Zip, Tel#.

I have a word document called "Letter to Special Members". This includes a text letter. I would like to use this as a form. Apart from other form fields the form would have 7 form fields:Name, Addr1, Addr2, City, State, Zip, Tel#.

What I want to do is have the first field "Name" be a drop down list of the member's names. Once this was chosen the other fields would automatically be filled with the information in the Excel document.

I don't want this like a mail merge where multiple letters or labels are made. I want to specifically choose the member's name and get the form automatically filled out.

How can I do this?
Reply With Quote
  #2  
Old 10-15-2014, 06:34 PM
Charles Kenyon Charles Kenyon is offline Lookup table in word Windows 7 64bit Lookup table in word Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,454
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

Look again at Mail Merge. You simply need to use "select recipients" to pick who the letter goes to.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup using 2 criteria Itsbarbara Excel 16 10-07-2013 02:53 PM
If lookup function samc Excel 3 03-10-2013 02:46 AM
Lookup angie.chang Excel 1 07-27-2012 09:45 PM
Lookup table in word Possible Lookup Karen222 Excel 3 01-10-2012 05:41 AM
Lookup table in word LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:44 AM.


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