How to Make a Mailing List Using Excel
Microsoft Excel is a software that allows users to create mailing lists with minimal experience. This spreadsheet application has other useful features such as, creating data lists, charts and forms. The mailing lists can be updated or new ones can be added after creating the list. This software can help to save time by simply creating a mass amount of mailing lists, instead of writing them by hand. Many small businesses find this to be a valuable tool.
Other People Are Reading
Instructions
-
How to Make a Mailing List Using Excel
-
1
Click on the "Start" button, located at the bottom left corner of the task bar. Go to "All programs" then select, and click on "Microsoft Office" then "Microsoft Excel." A new blank spreadsheet will open up in Excel.
-
2
Enter data in each field, in the order of first name, last name, address, city, country, state and zipcode. After typing in each cell, press the "Tab" key to go to the next cell. For example, type the first name in cell A1 then press the "Tab" key to go to cell B1, then type the last name. Continue in the same order until you are finished. Save your work, the move to the next step.
-
-
3
Open Microsoft Office Word and choose the template that you would like to use for your mailing labels. Click on the "Mailings" tab, "Start Mail Merge" then, "Step by Step Mail Merge Wizard." The "Mail Merge Wizard" will appear.
-
4
Select your choice of document type, then "Next" to continue. Click on "Use and Existing," "Browse," "Open," "Select Sheet" then "OK." Select and click on "Greeting Line." Review everything to make sure that you are satisfied, then click "Complete the Merge."
-
1
Tips & Warnings
Press the Ctrl + Arrow key to more to the next section of text.
Save your work regularly by holding down the Ctrl + the S key.
References
- Photo Credit number background image by kuhar from Fotolia.com
