Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-17-2012, 06:07 AM
allenglishboy allenglishboy is offline Multiple mail merge records on the same page Windows XP Multiple mail merge records on the same page Office 2003
Novice
Multiple mail merge records on the same page
 
Join Date: Dec 2011
Posts: 10
allenglishboy is on a distinguished road
Default Multiple mail merge records on the same page

1.How can I have multiple mail merge records on the same page instead of having one per page.




2.Each Record also has one of 12 headers. The headers are orders from 1 to 12. Is there a way I can get the header to only display when it changes.
Reply With Quote
  #2  
Old 07-17-2012, 04:03 PM
macropod's Avatar
macropod macropod is offline Multiple mail merge records on the same page Windows 7 64bit Multiple mail merge records on the same page 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

It's not clear what you mean. From what you've described, one of at least three possible solutions might apply, but they're all quite different. It would be helpful if you could attach a copy of the document and a representaive set of your source data to a post (delete any sensitive data). You do this via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-18-2012, 02:53 AM
allenglishboy allenglishboy is offline Multiple mail merge records on the same page Windows XP Multiple mail merge records on the same page Office 2003
Novice
Multiple mail merge records on the same page
 
Join Date: Dec 2011
Posts: 10
allenglishboy is on a distinguished road
Default

Hi

I cant upload the file, because I cant upload files at work. I will try to explain the first point. Each record is only about 4 lines of text instead of having each record on a separate page I would like to have about 3 or 4 records per Page. How would I do this?
Reply With Quote
  #4  
Old 07-18-2012, 06:22 AM
macropod's Avatar
macropod macropod is offline Multiple mail merge records on the same page Windows 7 64bit Multiple mail merge records on the same page 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

Given that you're working with varying numbers of records per page, you may be able to use Word's Catalogue/Directory Mailmerge facility (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial, in the 'Sticky' thread at the top of this forum:
Microsoft Word Catalogue/Directory Mailmerge Tutorial
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 recent, worked examples, see the attachment to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327

Alternatively, you may want to try the Many-to-One Mail Merge add-in from Graham Mayor at: Merge Many To One
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple mail merge records on the same page mail merge multiple recipients per page bmobrien Mail Merge 3 02-23-2012 10:47 PM
Multiple mail merge records on the same page Deleting records/results from mail merge alexb123 Mail Merge 2 08-12-2011 02:27 PM
Multiple mail merge records on the same page Multiple Mail Merge? imogul Mail Merge 1 06-24-2011 07:20 PM
Multiple mail merge records on the same page Mail Merge - Many Records for Each Addressee awalker1970 Mail Merge 1 12-31-2010 11:52 AM
Multiple mail merge records on the same page Combine Records when Mail Merge from Access Tom Pickles Misc 2 08-24-2010 06:00 PM

Other Forums: Access Forums

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