Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-30-2014, 05:34 AM
ScottA ScottA is offline Change break type for merge results Windows 7 64bit Change break type for merge results Office 2010 32bit
Advanced Beginner
Change break type for merge results
 
Join Date: Apr 2014
Posts: 30
ScottA is on a distinguished road
Default Change break type for merge results

I have created a custom reservation calendar for my brother's business and I'm not getting the results I need.

I'm not sure this thread belongs here but because the file is the result of a merge I thought I would start out here. Please move if needed.

I need to have the output of this merge to be mirrored margins so that the pages can be printed back to back to be place in a notebook. The merge works fine but the pages are all coming out as "odd" pages. From my reading I'm guessing that the issue is in the --Section Break (New Page)--.



Is there a way to set up the merge to have each record be a "next" page (sorry don't know the proper term)?

Alternatively - Can someone tell me what to replace the section break with to achieve the desires results? I've exhausted my knowledge in the replacing dialog box and replace special characters.

I hope that is clear. If not please let me know and I'll try to explain better.

Files attached
Attached Files
File Type: docx Reservation Book - merge layout.docx (84.0 KB, 7 views)
File Type: xlsx Reservation Book merge data.xlsx (10.6 KB, 6 views)
File Type: docx Merge Result.docx (174.4 KB, 8 views)
Reply With Quote
  #2  
Old 05-30-2014, 05:49 AM
macropod's Avatar
macropod macropod is offline Change break type for merge results Windows 7 32bit Change break type for merge results Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Try running your merge as a label or directory merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-31-2014, 06:06 AM
ScottA ScottA is offline Change break type for merge results Windows 7 64bit Change break type for merge results Office 2010 32bit
Advanced Beginner
Change break type for merge results
 
Join Date: Apr 2014
Posts: 30
ScottA is on a distinguished road
Default

Paul -

Took a bit to figure out all the different settings but finally got it to work using the directory / catalog merge vs the letter merge.

I used to think I had a pretty good handle on merges. There are obviously some differences in the types of merges that are not readily apparent. Is there additional documentation that you would recommend that will help me understand things better? I'd like to move my knowledge to the "next level"

Thanks for your help! (Again)
Reply With Quote
  #4  
Old 05-31-2014, 06:11 AM
macropod's Avatar
macropod macropod is offline Change break type for merge results Windows 7 32bit Change break type for merge results Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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 ScottA View Post
Took a bit to figure out all the different settings but finally got it to work using the directory / catalog merge vs the letter merge.
From what I saw of your document, I thought all it would take would be a change of the merge type.
Quote:
Is there additional documentation that you would recommend that will help me understand things better? I'd like to move my knowledge to the "next level"
You might regret asking that! To see what you can achieve with Word's Directory Mailmerge tools, using any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327
http://windowssecrets.com/forums/sho...l=1#post928391
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Change break type for merge results Page Break on Key Change bufferemail Mail Merge 7 05-11-2014 10:21 PM
2013 search results take a long time - they fill in as results in reverse date order themookman Outlook 0 10-11-2013 12:01 PM
Change break type for merge results showing results of If statements in a mail merge m&co Mail Merge 3 01-06-2012 07:27 PM
Change break type for merge results Deleting records/results from mail merge alexb123 Mail Merge 2 08-12-2011 02:27 PM
Instant Search's "Display search results as I type when possible" with Exchange lwc Outlook 0 06-01-2011 01:56 AM

Other Forums: Access Forums

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