Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2016, 03:57 AM
Lizzie Lizzie is offline Mail merge to create paper address book page Windows 7 64bit Mail merge to create paper address book page Office 2010 64bit
Novice
Mail merge to create paper address book page
 
Join Date: Jan 2016
Posts: 5
Lizzie is on a distinguished road
Default Mail merge to create paper address book page


I would like to use an excel spreadsheet with contact details to populate a paper address book. I want to format the pages nicely so they can be read easily and new entries added by hand.

I created a single page with separate tables but cant find out how to merge more than one record per page.

Any help gratefully received.

I have attached an image of how I would like the finished product to look -
Address book.PNG
Reply With Quote
  #2  
Old 01-27-2016, 02:15 PM
macropod's Avatar
macropod macropod is offline Mail merge to create paper address book page Windows 7 64bit Mail merge to create paper address book page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

You could do that with a directory merge. Here's how:
1. Do the initial setup for a directory merge, connecting the document to the data source.
2. Create a table like the one for your A example.
3. Populate the table with your required mergefields.
4. Insert two paragraph breaks after the table.
5. Insert a «Next Record» field into the first paragraph after the table.
6. Copy the table and paste it into the second paragraph after the table.
7. Shade the first or second table.
8. Make sure there is nothing after the second table except for two paragraph breaks
9. Run the merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-27-2016, 02:41 PM
Lizzie Lizzie is offline Mail merge to create paper address book page Windows 7 64bit Mail merge to create paper address book page Office 2010 64bit
Novice
Mail merge to create paper address book page
 
Join Date: Jan 2016
Posts: 5
Lizzie is on a distinguished road
Default

That is amazing!

I have spent hours trying to get this to work and seem to have been making a meal of it!

Worked exactly as I wanted.

Thank you very much indeed
Reply With Quote
  #4  
Old 01-28-2016, 04:03 AM
Lizzie Lizzie is offline Mail merge to create paper address book page Windows 7 64bit Mail merge to create paper address book page Office 2010 64bit
Novice
Mail merge to create paper address book page
 
Join Date: Jan 2016
Posts: 5
Lizzie is on a distinguished road
Default

Hi sorry if this is reopening a 'Solved' thread but to push my skills a bit further - how could I force a page break on change of first letter of surname???

I have added a column to the spreadsheet to show first letter and sorted by this letter - how can I translate that into a page break in the mail merge?

Thank you for your time
Reply With Quote
  #5  
Old 01-28-2016, 04:04 PM
macropod's Avatar
macropod macropod is offline Mail merge to create paper address book page Windows 7 64bit Mail merge to create paper address book page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

That could be done, but it's fiddly to set up in Excel (requires another column to test the first letter of each surname) and the field coding is relatively complicated, for something that requires, at most, pressing Ctrl-Enter 25 times in the mailmerge output document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge to create paper address book page Mail merge from excel - need to create sheets and create a table bluenosebex Mail Merge 5 08-02-2015 05:34 PM
Mail merge to create paper address book page Would like to mail merge excel spreadsheet with word doc and create new page when a catagory changes esherwood Mail Merge 1 07-21-2014 09:55 PM
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
Mail merge and address book CDTom Mail Merge 0 01-17-2012 09:08 AM
Mail merge to create paper address book page E-mail and address book question Gary Tayman Outlook 6 06-13-2011 01:46 AM

Other Forums: Access Forums

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