Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-17-2012, 06:07 AM
allenglishboy allenglishboy is offline Windows XP Office 2003
Novice
 
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 online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 10,288
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
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
[MS MVP - Word]
Reply With Quote
  #3  
Old 07-18-2012, 02:53 AM
allenglishboy allenglishboy is offline Windows XP Office 2003
Novice
 
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 online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 10,288
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
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 at:
http://windowssecrets.com/forums/sho...ngs-(2000-2010)
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 recent, worked examples, see the attachment to the posts at:
http://www.msofficeforums.com/mail-m...html#post23345
http://www.msofficeforums.com/mail-m...html#post30327

Alternatively, you may want to try the Many-to-One Mail Merge add-in from Graham Mayor at: http://www.gmayor.com/ManyToOne.htm
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


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


All times are GMT -8. The time now is 09:37 PM.


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