#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge from excel - need to create sheets and create a table | bluenosebex | Mail Merge | 5 | 08-02-2015 05:34 PM |
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 |
E-mail and address book question | Gary Tayman | Outlook | 6 | 06-13-2011 01:46 AM |