Solved

Multiple Merged Field on a single word document

Posted on 2011-02-10
4
264 Views
Last Modified: 2012-08-13
We make awards constantly - currently, we are copying/pasting names onto a word document and printing - often times, the person is also typing in those names and errors are becomming a problem. Is there a way to take the document, have an excel spreadsheet of all the names going on the single award, and run a merge? To give an example, imagine we are awarding a team who won a championship. We'd like to put all those players name on the one document. The number of names would go up and down based on the team.
0
Comment
Question by:pstiffsae
  • 2
4 Comments
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 350 total points
ID: 34866260
You can just select the range in the Excel workbook and paste it into a Word document; it will appear as a Word table.
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34866267
Ctrl-C to copy the range in Excel; Ctrl-V to paste it into a Word document
0
 
LVL 76

Assisted Solution

by:GrahamSkan
GrahamSkan earned 150 total points
ID: 34867066
If you want to use mail merge, you would need use a Directory type of merge.
0
 
LVL 39

Expert Comment

by:als315
ID: 34882200
Test this answer:
http://rdsrc.us/eZ8BoV
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 is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
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…

943 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

10 Experts available now in Live!

Get 1:1 Help Now