Skip to main content

Microsoft Word Mail Merge

Mail Merge is extremely simple in Word 2010 however it seems that because I don't use it as often, I always have to dig around and find out how to use it. Here are the step-by-step instructions on how to easily do mail merge.

1. Create an Excel Sheet with headers in the top row (i.e. Name | Address | Street | ST | Zip)
2. Populate the Excel sheet with the content. Save upon completion.


3. Open Word 2010
4. Click the Mailings tab.


5. Click Start Mail Merge and select Labels.


6. Select Label Vendor (i.e. Avery) and select Product Number (i.e. 5160 Easy Peel Address Labels). Click OK.


7. Click on the Select Recipients and select Use Existing List.


8. Browse and find your Excel Sheet and Click OK. Make sure that First row of data contains column headers is checked.


9. Make sure that your cursor is in the first label (the one that is empty and doesn't contain the <<Next Record>> tag).


10. Click Insert Merge Field and select the Labels that you want (i.e. Name, Address, etc)


11. Format to your liking (i.e. add spaces, new lines). 


12. If your contents seem to be going off of the label when adding new lines, click the Home tab and under the paragraph portion click the Line and Paragraph Spacing (Up and Down arrow). Select Remove Space Before Paragraph. Note: your cursor needs to be at the beginning of the label (i.e. in this case before Name).


13. Go back to the Mailings tab and click Update Labels.


14. Click Finish & Merge and Select Edit Individual Documents.


15. Make sure that All is selected and click OK.


16. Insert paper into printer and click print.

Comments

Post a Comment

Popular posts from this blog

Beginner Java Exercise: Sentinel Values and Do-While Loops

In my previous post on while loops, we used a loop-continuation-condition to test the arguments. In this example, we'll loop at a sentinel-controlled loop. The sentinel value is a special input value that tests the condition within the while loop. To jump right to it, we'll test if an int variable is not equal to 0. The data != 0 within the while (data != 0) { ... } is the sentinel-controlled-condition. In the following example, we'll keep adding an integer to itself until the user enters 0. Once the user enters 0, the loop will break and the user will be displayed with the sum of all of the integers that he/she has entered. As you can see from the code above, the code is somewhat redundant. It asks the user to enter an integer twice: Once before the loop begins, and an x amount of times within the loop (until the user enters 0). A better approach would be through a do-while loop. In a do-while loop, you "do" something "while" the condition
12 comments
Read more

Programming Language Concepts Questions/Answers Part 3

1. What is an associative array? - An unordered collection of data elements that are indexed by keys. 2. Each element of an associative array is a pair consisting of a _______ and a _______. - key and a value 3. True or False? Java supports associative arrays? - True. As a matter of fact, Perl, Python, Ruby, C++, C# and F# do too. 4. What are associative arrays called in Perl? - hashes 5. Why are associative arrays in Perl called hashes? - Because their elements are stored and retrieved with a hash function 6. What character does a hash in Perl begin with? % 7. In Perl, each key is a _____ and each value is a _______. - string - scalar 8. In Perl, subscripting is done using _______ and _______. - braces and keys 9. In Perl, how are elements removed from hashes? - using delete 10. In Perl, the ________ operator tests whether a particular value is a key in a hash. - exists 11. What are associative arrays called in Python? - dictionaries 12. What is a dif
6 comments
Read more

Creating your own ArrayList in Java

Wanted to show that certain data structures in Java can be created by you. In this example, we'll go ahead and create an ArrayList data structure that has some of the methods that the built in ArrayList class has. We'll create 2 constructors: The default constructor that creates an ArrayList with a default size of 10. Constructor that allows an initial size to be passed to the array. We'll also create a number of methods: void add(Object x);  A method that allows you to place an Object at the end of the ArrayList. void add(int index, Object x);  A method that allows you to place a value at a given location. Object get(int index):  Allows you to retrieve a value of the arrayList array from a given location. int size();  Allows you to get the number of elements currently in the Arraylist. boolean isEmpty();  Tests to see if the Arraylist is empty. boolean isIn(Object x);  A method that sees if a particular object exist in the arrayList. int find(Object x);  
50 comments
Read more