Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

importing excel data into

Forum home » Delegate support and help forum » Microsoft Word Training and help » Importing excel Data into an existing word table

Importing excel Data into an existing word table

ResolvedVersion 2007

Daniel has attended:
Word Intermediate course
PowerPoint Intermediate Advanced course
Excel Intermediate course

Importing excel Data into an existing word table

Hi there,

I have a list of 250 names that are attending an event. I need to create name badges for all of them.

We have an existing Label Template (essentially a table but created specifically for the labels and printers we use), into which I need to paste these names.

Without going into each box and pasting the name of the attendee, is there a way I can do all at once?

My thanks in advance for your quick response.

RE: Importing excel Data into an existing word table

Hi Daniel

Thanks for your post. By what you describe the best method to use is mail merge.

This is a facility which enables you to merge data from a source, say Excel information, into a pre-formatted Word document, like the Label Template you use at work.

This certainly will save you time. For more information on mail merge, I recommend you search our hints & tips section, please follow the link:
https://www.stl-training.co.uk/hints-tips-word-15.html

Alternatively for hand-on instruction on mail merge, this is one of the units we cover in our Word advanced training course.
https://www.stl-training.co.uk/word-and-excel-courses-london.php

Hope this helps.

Kind regards

Jacob

RE: Importing excel Data into an existing word table

Many thanks Jacob.

I'll start having a look now.

Dan

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Word tip:

Print Word documents without opening them first

Here's a fast way of printing a Word document from Windows Explorer/My Computer.

Go to the location where the document is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The document will automatically open, print and close itself.

View all Word hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.