get address Data for WORD

[AndyB]

Is there a MACRO that when you get to it in a WORD doc will open a listbox
(or similar dialog) that will access and external data source (Excel or
MSAccess etc). This list box will display basic info (name etc). When a
record is selected the routine would populat data into the WORD doc. for an
Address or other info to be used in the document.

Help would be greatly appreciated

AndyB

 

[Greg Maxey]

You might get started by looking at:

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

 

[AndyB]

Thanks Greg, I'll give it a good look
AndyB

You might get started by looking at:

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

 

[AndyB]

This is a great resource, thanks. I have been experimenting withforms E and
F (pulling data from an ACCESS Table).

is there a way for the entries in the listbox to be sorted? (either by
sorting the table before it is added or after)

With Form F is there a way to specify which fields will show in the ListBox?

Thanks for your help

AndyB