How to create a booklet in Word for Mac 2011 using mail merge??

Question

For years I have been printing a small pocket-sized address book using Word for Windows, and data in an Excel worksheet, but for the life of me can't figure out how to do it in Word for Mac 2011. Anyone have any suggestions?

Thank you!

Answer 1

Did the gutter appear out of nowhere when you printed? If you did set "Different odd and even" in Format > Document > Layout tab, it might come from there.

I'm not clear what you mean by "line breaks left line-spaces." In my screenshot above (at the time, I had two columns and the page was actually twice as wide as what you'd be doing now), this is what I had:

https://skydrive.live.com/?cid=8e8a02160c54764f#cid=8E8A02160C54764F&id=8E8A02160C54764F%21259


https://public.bay.livefilestore.com/y1puuOlSPkw-uu7wuEszUxh4bfdDQO1OUqWZtSTBxNOoqUWip24b1-if-ccurl_-IA4a1RWMbb5XUmt7u-cmwJSKA/20111208a.png?psid=1https://public.bay.livefilestore.com/y1puuOlSPkw-uu7wuEszUxh4bfdDQO1OUqWZtSTBxNOoqUWip24b1-if-ccurl_-IA4a1RWMbb5XUmt7u-cmwJSKA/20111208a.png?psid=1

The horizontal line was obtained as described in step 5. Did it show on screen?

The vertical line only shows once the fields are populated so as to have two columns. However, in your single page document, you could add a vertical line on the side, using an odd/even header.

Answer 2

1. Go to File > Page Setup and in the third dropdown menu, select Manage custom sizes.

2. Define a page measuring 2.75" x 4.25", with .4" margins all around (alternatively, define them as 0" and set the document's margins to .4").

3. Enter the fields in the document, where <LB> is a line break (Shift Return). This is best done in step 8 below:

«Last_Name», «First_Name»<TAB>«Phone»<LB>

             «Address_1»<LB>

«Address_2»<CR>

<CR>

4. Select the field paragraph and apply a small Space After (like 6 pt) as well as Keep Lines Together. Alternatively, apply 3 pt before and 3 pt after.

5. Select both paragraphs and apply a line in between (Format > Borders and Shading).

6. Open Tools > Mail merge manager and set it up as Catalog (merge Step 1).

7. Open your data file (merge Step 2). I tried it an .xlsx and .csv file, they both worked (although a file "conversion" was required). They data was in table format. The first row contained the 5 field names as shown in step 3 above. Then, the data in rows. I added blank fields and they worked OK (nothing was merged if blank, else the field's value was entered).

8. Drag your fields over to the document (merge Step 3).

9. Do the merge (merge Step 6, second icon).

Printing is the hardest part:

A. 4 pages per sheet: In the Print dialog, select Layout  in the third dropdown menu and choose 4 pages per sheet (assuming a paper sheets of 8.5 x 11)

B. Page order: Again in the third dropdown menu, select *Copies & Pages.*Click on Page Range and enter this sequence: 16,1,14,3,12,5,10,7. You can test by printing to a PDF or clicking on the Preview button, if there is one.

Print, turn your pages over, feed them back and print this range: 2,15,4,13,6,11,8,9.

Depending on how your printer stacks the paper output, you may need to enter one of the above sequences in reverse order, in groups of four (as there are 4 pages to a sheet): 6,11,8,9,2,15,4,13. You probably won't get it right the first time!

Also, you can print hairlines for the guillotine.

Answer 3

Try looking at these answers, all from this site: Google Search. Some are short, other are longer explanations. (Plus, the first Google result will probably be this thread.)

Or you can type "Booklet" in the Search field above, to get these results.

Should you need more help, please post back.

Answer 4

Most of these links were for previous versions of Word for Mac and of limited help. A couple were helpful. I'm still working on it.

Answer 5

Hi Dot:

I just wonder: have you been through the Word help in 2011?

However: essentially, nothing has changed.  They have moved the controls around (so I can't find them either...) but really, the process has been exactly the same for 20 years.

We could be much more help if you were to tell us exactly where you are having trouble.  Could you try this:

http://mac2.microsoft.com/help/office/14/en-us/word/item/efb15e68-5177-4ea2-9f64-c3c34ce584e7?category=81d8cb7e-a28d-41fe-b87b-62104e39d129

Tell us t which step you run into difficulty, and we can help you through the rest of it.

Cheers