Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-01-2015, 01:53 PM
Murph14 Murph14 is offline Windows 7 32bit Office 2013
Novice
 
Join Date: May 2015
Posts: 3
Murph14 is on a distinguished road
Unhappy Directory Mail Merge Trouble


I am still having trouble with completing a multiple directory mail merge. I have watched all of the tutorials but can't figure it out. I have attached a sample sheet if anyone can help me get the multiple equipment tabs on 1 document that will be great.

Thank you
Attached Files
File Type: xlsx PracticeBook.xlsx (8.3 KB, 3 views)
Reply With Quote
  #2  
Old 06-01-2015, 09:21 PM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 2,201
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

This is a many to one mail merge and is complicated to achieve with a directory merge as you have discovered. However, you could use http://www.gmayor.com/ManyToOne.htm using the first column as a key field and the second as a child field, naming the documents (one for each key change) with the first field.

If you want the documents combined then the current version of the add-in doesn't do that, but you can join them with http://www.gmayor.com/Boiler.htm
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 06-02-2015, 06:35 AM
Murph14 Murph14 is offline Windows 7 32bit Office 2013
Novice
 
Join Date: May 2015
Posts: 3
Murph14 is on a distinguished road
Default

so the typical {QUOTE{IF{MERGESEQ}= 1 {SET Key ""}}"{IF{MERGEFIELD State}<> {Key} "{IF{MERGESEQ}> 1 "{QUOTE 12}"} won't work in this situation?
Reply With Quote
  #4  
Old 06-02-2015, 07:39 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 2,201
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

That's not what I said. If you want a tutorial on that method then see Paul Edstein's tutorial from the downloads page of my web site.

The add-in simply makes the task easier.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 06-02-2015, 09:54 AM
Murph14 Murph14 is offline Windows 7 32bit Office 2013
Novice
 
Join Date: May 2015
Posts: 3
Murph14 is on a distinguished road
Default

I must be doing something wrong because when I tried to download your plug in it was blank and I have tried the tutorial multiple times but it does not seem to work either.
Reply With Quote
  #6  
Old 06-03-2015, 12:22 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 2,201
gmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the roughgmayor is a jewel in the rough
Default

What was blank? The download link is at the bottom of the web page. It links to http://www.gmayor.com/Zips/ManyToOneMailMerge.zip
The zip contains a template, an installer and example files.
Read the page for instructions.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
directory, mail merge, multiple

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
table format after mail merge (directory) laboymc Mail Merge 0 03-16-2015 07:17 AM
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
Detecting Page Breaks in Mail Merge Directory TimK9VB Mail Merge 6 11-20-2012 01:52 PM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft