Solved

Mail Merge 400 communion cards

Posted on 2011-10-01
3
154 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 93

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 93

Expert Comment

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

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

856 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