Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 06-23-2015, 06:01 PM
macropod's Avatar
macropod macropod is offline After Mail merging single documents - how to combine several documents into one? Windows 7 64bit After Mail merging single documents - how to combine several documents into one? 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


Quote:
Originally Posted by Abacus1234 View Post
I don't understand why I have to have a Mergefield in the WHERE clause. Also, when I try it through Quickparts it does not select the fields that I ask for. I have attached what the final report looks like. Thanks.
Since you've been describing the process as one that uses mailmerge and you referred to the need to incorporate 'a multi-record table', I assumed the table you wanted to generate varied according to a condition applicable to whichever record is being merged. In that case, the DATABASE field needs to perform that test. I'm not surprised that you can't accomplish this using Insert|Quick Parts|Field, as what's being done here is rather more than that tool was designed for. You could get further via Mailings|Insert Mergefield and Mailings|Rules, but even those probably won't go the distance - in which case you'll need to create the fields manually, using Ctrl-F9 to create the field braces and typing the relevant expressions between them. Of course, all this is moot if my assumption was wrong.

Indeed, the table in your latest attachment looks as if it's a standard one in which just the values change and the data all relate to a single record. In that case, you don't even need a DATABASE field. You should be able to do the lot via IF fields and MERGEFIELDS alone.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #17  
Old 06-25-2015, 06:56 AM
Abacus1234 Abacus1234 is offline After Mail merging single documents - how to combine several documents into one? Windows Vista After Mail merging single documents - how to combine several documents into one? Office 2010 32bit
Novice
After Mail merging single documents - how to combine several documents into one?
 
Join Date: Nov 2011
Posts: 24
Abacus1234 is on a distinguished road
Default

I will mark this thread as solved in the sense that I have understood a path that will not provide the solution I need. It is a neat way of pulling data into a document, but lacks the formatting capability I would need. Thanks for the extended help.
Reply With Quote
Reply

Tags
combine documents, mail merge



Similar Threads
Thread Thread Starter Forum Replies Last Post
After Mail merging single documents - how to combine several documents into one? Combine documents makes duplicate word vincelge Word 2 05-15-2017 05:47 AM
After Mail merging single documents - how to combine several documents into one? Mail Merge with Booklets is Merging all documents into One stapled Booklet 15Degrees Mail Merge 1 01-31-2013 02:06 AM
combine multiple documents word starter 2010 bribelge Word 3 12-19-2012 09:25 AM
After Mail merging single documents - how to combine several documents into one? OK I know its a dumb question but how can I combine word documents? hellno187 Word 2 12-16-2012 12:32 PM
How can a combine three seperate word documents into one? hellno187 Word 0 09-20-2010 02:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:33 PM.


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