Thread: [Solved] Pick individual excel line from table to merge to WORD
View Single Post
 
Old 04-14-2016, 05:50 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote