Merging data from excel (.xls) file, text file(.txt), and wordpad to your word (.doc) document.
Posted by wishbonemehk on March 28, 2009
You can import data from any text documents like excel, word, notepad, and wordpad. If you want to optimize your work, you can use this technique. For example, you are writing and printing a letter to all of your recepients on your addressbook, you can create a body of the letter for everybody and then use the wizard to get the data from your address book(your address book is any of the text documents metioned above).
Here are the step-by-step procedures:
1. Open your word document and start writing each part of the letter, leaving the name and address of the recepient blank.
2. Next look for Mail Merge on the menus. For Office 2007, click Mailings and select Start Mail Merge.
3. Mail merge menu will appear on the right, you will have to select what type of document you are working on. On this case, we will select letters then click the Next: Starting Document link.
4. Select your starting document, we would like to use the current document so we will choose Use the current Document
5. Next you have to select your recepients. You can choose recepients listed on your excel file or any text files, on your outlook address book or you can type and create a new list of recepients. In this case we will use the first option.
6. Click Next: Write your letter link at the bottom.
7. Next you will choose which address block and greeting line to use. Or you can import the list of your contacts located on your excel file or any text documents Simply browse and select that file.
8. Select what data will be displayed on your letter. For example you will selec the name and address because you want their name and addressess to be visible on your letter.
8. Then you can start previewing all your letter for every recepients.
9. If you are done, you can preview your letters or you can print all of them at once. You can also edit individual letters by clicking Edit individual letters link.
10. Lastly, you can now print your document. When you print, you can then specify the range of records you want to be printed out. You can select to print the current record or you can select to print all records.
That’s it. I hope that this method will help you optimize your desktop works. If I have missed something, just leave me a comment.
