Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2015, 01:53 PM
Murph14 Murph14 is offline Directory Mail Merge Trouble Windows 7 32bit Directory Mail Merge Trouble Office 2013
Novice
Directory Mail Merge Trouble
 
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, 9 views)
Reply With Quote
  #2  
Old 06-01-2015, 09:21 PM
gmayor's Avatar
gmayor gmayor is offline Directory Mail Merge Trouble Windows 7 64bit Directory Mail Merge Trouble Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,098
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

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) (2002-2019)
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 Directory Mail Merge Trouble Windows 7 32bit Directory Mail Merge Trouble Office 2013
Novice
Directory Mail Merge Trouble
 
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 Directory Mail Merge Trouble Windows 7 64bit Directory Mail Merge Trouble Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,098
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

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) (2002-2019)
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 Directory Mail Merge Trouble Windows 7 32bit Directory Mail Merge Trouble Office 2013
Novice
Directory Mail Merge Trouble
 
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 Directory Mail Merge Trouble Windows 7 64bit Directory Mail Merge Trouble Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,098
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

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) (2002-2019)
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
Directory Mail Merge Trouble Detecting Page Breaks in Mail Merge Directory TimK9VB Mail Merge 6 11-20-2012 01:52 PM

Other Forums: Access Forums

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