![]() |
#1
|
|||
|
|||
![]()
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? |
#2
|
|||
|
|||
![]()
Look again at Mail Merge. You simply need to use "select recipients" to pick who the letter goes to.
|
![]() |
|
![]() |
||||
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 |
![]() |
Karen222 | Excel | 3 | 01-10-2012 05:41 AM |
![]() |
aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |