Solved

Multiple Merged Field on a single word document

Posted on 2011-02-10
4
269 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
[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
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 40

Expert Comment

by:als315
ID: 34882200
Test this answer:
http://rdsrc.us/eZ8BoV
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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…
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…

737 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