98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:Closing all your documents QuicklyHold 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. |