Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mail merge
Dear ALL, My name is Gautam and i m new here... i have a specific query regarding my project. I want to make a template in word where my product (ie engine) is selected from the drop down menus and all information pertaining to that is filled in the lines below automatically. EG. If i selected engine "A" then its parameters ie bore, stroke, piston speed etc.. should be filled automatically in the template below... I have done this successfully in EXCEL by data validation and VLOOKUP but dont know for WORD. Please help Thanks in advance Gautam -- gmahendru ------------------------------------------------------------------------ gmahendru's Profile: http://www.highdots.com/forums/m1086 View this thread: http://www.highdots.com/forums/t3051115 |
#2
|
|||
|
|||
mail merge
You could run a macro similar to this on exit from the dropdown so that it
would insert the information stored as autotext for each engine name: ' Macro created 15-11-97 by Doug Robbins to add the address corresponding to a drop down name ' Set myDrop = ActiveDocument.FormFields("Dropdown1").DropDown Company = myDrop.ListEntries(myDrop.Value).Name Address = ActiveDocument.AttachedTemplate.AutoTextEntries(Co mpany).Value ActiveDocument.FormFields("Text1").Result = Address -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "gmahendru" wrote in message ... Dear ALL, My name is Gautam and i m new here... i have a specific query regarding my project. I want to make a template in word where my product (ie engine) is selected from the drop down menus and all information pertaining to that is filled in the lines below automatically. EG. If i selected engine "A" then its parameters ie bore, stroke, piston speed etc.. should be filled automatically in the template below... I have done this successfully in EXCEL by data validation and VLOOKUP but dont know for WORD. Please help Thanks in advance Gautam -- gmahendru ------------------------------------------------------------------------ gmahendru's Profile: http://www.highdots.com/forums/m1086 View this thread: http://www.highdots.com/forums/t3051115 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
Mail Merge - Parameter prompts twice... | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge |