Solved

Mail Merge 400 communion cards

Posted on 2011-10-01
3
157 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 96

Accepted Solution

by:
Experienced Member 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 96

Expert Comment

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

631 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