Do you know anything about Excel and/or Word??

Question

Here's my problem- I have to copy/paste 150 individual names from excel and paste each name, one by one, onto a certificate in word. So, I have to copy one name from excel, paste it on the document in word, print it out, copy another name from word, delete the name that was used on the document, insert the new name, and repeat and repeat and repeat. Instead of copy/pasting every single name which would take me a while, is there a way to copy/paste all of the names at once so each name shows up one by one on it's own certificate? I think it's called something like 'mail merger' or 'mergering'. If anyone can help I will be so thankful!

Answer 1

There is mail merge. But that usually works from one word file to another. ~
Try to open the Excel file with word and then check 'Help' for merge instructions.
I just did a test and Excel files will import into word just fine!

Answer 2

Yes, you can do it. But you may have to paste or import them into Outlook's Contact List. Since that is a default choice, it would be easier
But I went and looked for Excel directly and found: Under Tools there is Letters and Mail Merge. then Mail Merge, from the list select Letters and then select Use Current document. In the lower right is a link for the steps, go to select recipients and then Use Current list and there select Browse you will be presented with a default choice, but if you go through the lower drop down list you will find Excel files. From here on you are on your own as I don't have a handy list to test.

Answer 3

Use mail Mail Merge. Open a MS word document, under tools select "Mail Merge"

1.Follow the steps to create your main document.
2. Use your current excel data as your data source. When you create you data in excel you need to label the heading as: last name, first name. This will will identify each person.

3.Merge Data with Document. On you tool bar you will see something like, "Insert Merge Field". When you click on it you will see the data that available for merging.

I hope this will help.

Answer 4

Dear .
please use word for ur certificate and creata sample in the mail merge, it will ask u for several names as well put them there for once and good
than on the sample just put where u want names and adress and all the it will print all the names that are required simples.

Or you can import the excel into the word and use it there is a option for the try to use insert option and u will suucceed

Answer 5

yes its called mail merge.
If you have all the names listed in Excel. then you go into word, use the certificate as the main document and select mail merge, it should ask you where to get the data to insert. then you tell it to go to this excel document. each data insert should have a label or name. example. if you needed to insert first name. then label it so. you should be able to lookup in the help section in word and find mail merge to walk you through it.

Answer 6

You can use the Mail Merge option. Close the Excel documtent and open the word document then click on Tools, then Letters and Mailings, and then Mail merge. It talks you right through it.