Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Mail Merge 400 communion cards

Posted on 2011-10-01
3
Medium Priority
?
158 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 98

Accepted Solution

by:
John Hurst earned 2000 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 98

Expert Comment

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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

715 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