Solved

Multiple Merged Field on a single word document

Posted on 2011-02-10
4
266 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

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…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

832 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