Solved

Mail Merge 400 communion cards

Posted on 2011-10-01
3
155 Views
Last Modified: 2012-06-27
I have 400 communion cards  to print off on standard avery busines cards. I have set up the template but i get the same details on the whole page, ie i am getting 400 pages! I have tried everything and cant seem to get this to work, is it possible?
0
Comment
Question by:bryanscott53
  • 2
3 Comments
 
LVL 94

Accepted Solution

by:
John Hurst earned 500 total points
ID: 36897331
Did you use the Mail Merge Wizard? I can never remember how the wizard works. Here is a set up steps I worked out for a colleage. The output was Avery Labels, but that should work for your Avery Cards.

Mail Merge Wizard steps.
(i) Select Labels and Click on Next on Bottom
(ii) Select Change Document Layout, click on Label options and Select type 8160  <-- select your type
(iii) Select Recipients, use existing list, select Browse, click on Desktop and select Christmas Address List (or other list). Use First Address Table list and click on OK. See that the whole list is already selected and click OK
(iv) Arrange Labels
    Note: Plae cursor in the first label on the screen (which is blank) and not any other label.
    Click on More Items which shows Insert Merge Fields.
    Select all given fields using Insert button or double clicking on each field.
    Notice the fields are now in the first label.
    Edit label
    Click on Update all labels
(v) Preview
(vI) Complete merge and print.

Try that and see if it works. The trick is to work through each and every step on the Wizard. Your precise steps may vary if you have a different version .  

.... Thinkpads_User
0
 

Author Closing Comment

by:bryanscott53
ID: 36939145
brilliant thanks for your help this worked
0
 
LVL 94

Expert Comment

by:John Hurst
ID: 36939199
That's great. Thank you and I was pleased to assist.
... Thinkpads_User
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question