Solved

Mail Merge 400 communion cards

Posted on 2011-10-01
3
151 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 92

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 92

Expert Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

863 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now