Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-14-2016, 05:50 PM
macropod's Avatar
macropod macropod is offline Pick individual excel line from table to merge to WORD Windows 7 64bit Pick individual excel line from table to merge to WORD 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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a table in one document of WORD from EXCEL with Mail Merge Joseph.Comerford@bentley. Mail Merge 1 04-18-2015 01:19 AM
Pick individual excel line from table to merge to WORD Merge From Excel With Table in Word - Next Record If Excel Column Same? misscrf Mail Merge 2 10-15-2014 11:51 PM
Mail merge table from Excel to Word krezumica Mail Merge 2 03-06-2014 10:26 PM
Pick individual excel line from table to merge to WORD Importing individual cells from Excel to Word themangoagent Word 1 10-12-2009 08:14 AM
Pick individual excel line from table to merge to WORD Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft