View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rich Rich is offline
external usenet poster
 
Posts: 62
Default inserting the DATABASE field in a mailmerge with filtered reults

I have a Mailmerge document and I want to use the FIELD option (Insert,
Field on the toolbar) to display filtered results from a spreadsheet or
access table.

I am able to insert the DATABASE field but it shows all the rows the
spreasheet( retail.xls). i was wondering if there is a way to filter the
resutls so that ONLY the rows that have the same value as the PORTFILIO_ID
wordfield are displayed.

Any advice or info would be greatly appreciated