View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How to import certain fields from access database?

Use a userform that contains a combobox or list box that is populated with
data from the Access database.

See the following pages of fellow MVP Greg Maxey's website:

http://gregmaxey.mvps.org/Create_and...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

"Haroon" wrote in message
...
hi

i made a form using ms word 2003 vba with few textboxes, when the user
types
in one of the field, e.g. customer ref, the database imports few selected
field from databse into bookmarks on word document, e.g. customr name,
add,
date, etc.

i dont want to use the search option in mailmerge to find records, as i
also
want the user to type/add additional data on the textboxes in the form to
be
placed in bookmarks on document, as some data is not coming from database.

anyone got idea?

thanks in advance