mail merge

[gmahendru]

Dear ALL,

My name is Gautam and i m new here... i have a specific query regardin
my project.

I want to make a template in word where my product (ie engine) i
selected from the drop down menus and all information pertaining t
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 templat
below...

I have done this successfully in EXCEL by data validation and VLOOKU
but dont know for WORD.

Please help

Thanks in advance

Gauta

 

[Doug Robbins - Word MVP]

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(Company).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