importing excel data into

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

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

Importing excel Data into an existing word table | Word forum

resolvedResolved · Urgent Priority · Version 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:

Closing all your documents Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all documents down but still leaves the application open.

View all Word hints and tips


Server loaded in 0.09 secs.