Pick individual excel line from table to merge to WORD

[skiwidad]

Is it possible to reference an EXCEL spreadsheet containing a table of data (say 50 lines of open purchase orders) and bring information into a WORD document based on a field reference held in one column of the table

So I don't want to merge the whole table into WORD just to select say PO 1110111 and merge the fields from that line into the document.

The EXCEL table has a link to a shipping database and will refresh when opened. then the user wants to pick information from one shipment into the WORD document.

Thanks in advance

[macropod]

You could use either of two approaches:
1. Filter the mailmerge (via Mailings>Edit Recipient List), so that only the selected record is processed; or
2. Use a SKIPIF field with a prompt for the user to input the record to process. Such a field might be coded as:
{SKIPIF{FILLIN "Purchase order # to output." \o }<>{MERGEFIELD Purchase_Order}}
where 'Purchase_Order' is the name of the field holding the Purchase_Order numbers.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues.