Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 09-22-2020, 03:04 PM
macropod's Avatar
macropod macropod is offline Customize document content based on Mail Merge source fields? Windows 7 64bit Customize document content based on Mail Merge source fields? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

The simplest solution might be to create a single document that contains all the letter variants (or, at least the content that differs), with each variant given a unique bookmark name - preferably a name that matches the output from a field in the datasource that is used to discriminate between the letters, then use an INCLUDETEXT field in the mailmerge main document with a suitable MEREGEFILED in the bookmark reference position. For example:
Code:
{QUOTE{INCLUDETEXT "{FILENAME \p}/../Variations Document.docx" "{MERGEFIELD Variant}"}}
With the above construction, the document containing the variants would be named 'Variations Document' and stored in the same folder as the mailmerge main document. That document can even contain its own mergefields, if needs be. The {MERGEFIELD Variant} field would simply tell the INCLUDETEXT field which bookmark to look at, according to whatever;s stored in a data field named 'Variant' in the data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Customize document content based on Mail Merge source fields? Mail merge all fields into 1 document with rules MP1989 Mail Merge 6 06-27-2018 04:43 PM
Customize document content based on Mail Merge source fields? Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Alfred Mail Merge 2 05-23-2017 10:59 PM
Using 3 different fields, several times in same document but not en mass - should I use mail merge? shoughton Mail Merge 1 06-24-2015 02:46 PM
Merge fields in Word and source data from Excel SteveVai Mail Merge 3 03-13-2014 05:25 AM
dynamic charts based on mail merge fields jwajehee Mail Merge 0 10-05-2011 09:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:16 AM.


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