From: MT Laz on 3 May 2010 15:45 I wish to create a field in a Word form that will enable me to use a drop down (or equivalent) to choose from a list of "Mailing Labels" which each include Name, Address, City, St, Zip. Using a drop down form field only allows me one line of information, and I need 3. -- Montana Laz
From: Doug Robbins - Word MVP on 3 May 2010 17:46 If you had the address details stored as autotext entries, you could use the following code on exit from a DropDown type FormField to insert the address corresponding to the selected name (company in the case for which the following code was created) into a Text FormField on the following line. ' 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("Address").Result = Address The alternative, and probably better approach is to use a userform See the following pages of Greg Maxey's website : http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm -- 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, originally posted via msnews.microsoft.com "MT Laz" <MTLaz(a)discussions.microsoft.com> wrote in message news:D2C4043F-8DE3-4634-9F3D-79173A129F8A(a)microsoft.com... > I wish to create a field in a Word form that will enable me to use a drop > down (or equivalent) to choose from a list of "Mailing Labels" which each > include Name, Address, City, St, Zip. Using a drop down form field only > allows me one line of information, and I need 3. > -- > Montana Laz
|
Pages: 1 Prev: MsgBox with number of paragraphs formatted with a user-defined paragraph style Next: Search |