Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-12-2015, 01:14 PM
htsu htsu is offline Word 2010 - directory mail merge - two separate group of data in one document Windows 7 32bit Word 2010 - directory mail merge - two separate group of data in one document Office 2010 32bit
Novice
Word 2010 - directory mail merge - two separate group of data in one document
 
Join Date: Mar 2015
Posts: 1
htsu is on a distinguished road
Default Word 2010 - directory mail merge - two separate group of data in one document

Is it possible to create a form letter that has two distinct areas for two separate groups of data? For example, an acknowledgement to a customer for a recent order. The letter can list all items that will ship immediately and also list all items that is backordered.



Thanks advance for your help.
Reply With Quote
  #2  
Old 03-13-2015, 12:13 AM
gmayor's Avatar
gmayor gmayor is offline Word 2010 - directory mail merge - two separate group of data in one document Windows 7 64bit Word 2010 - directory mail merge - two separate group of data in one document Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

No - you can only merge a single data source. You can however merge Many to One with http://www.gmayor.com/ManyToOne.htm if you have the data setup appropriately. You can probably derive a suitable worksheet from your existing two sources.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-07-2016, 03:10 PM
macropod's Avatar
macropod macropod is offline Word 2010 - directory mail merge - two separate group of data in one document Windows 7 64bit Word 2010 - directory mail merge - two separate group of data in one document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

I know this is an old thread but, FWIW, you could do this with a letter merge and two DATABASE fields (one each for the 'ship immediately' items and the backorder items), even if they're in different files, provided all data sets have a common key (e.g. client ID#).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
directory merge, two groups of data

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Directory Mail Merge with table layout 3N1GM4 Mail Merge 11 06-03-2014 09:54 PM
Directory Mail Merge Issues dbpros_crm Mail Merge 10 01-20-2014 11:05 PM
Mail Merge Directory - Combining fields officegirl Mail Merge 1 03-21-2013 11:02 PM
converting a word document to a data file for mail merge drsuis Mail Merge 4 02-21-2013 03:34 PM
Any easy way to separate a Word document into separate files? SamHelm Word 0 08-21-2010 05:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:55 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