Access Tutorials

When you use a database program like Microsoft Access 2007 you deal with large amounts of data daily, so one of the things that you also do often is mass mailings. Lucky for you, Access has a great function that lets you create mailing labels in just a couple of clicks. In this short tutorial, I will show you how to create mailing labels for massive mailings.

1. First, make sure you have open the database that has the information you want to include in your mass mailing. Next, go to Create>Reports>Labels, and the Lable Wizard will open up.
2. The “Label Wizard” pop up window box will appear. Next, from the group of label options, select the labels that you will be using for the printing of the labels, and also search the correct label manufacturer, and click Next.
3. Next, you can select the font type, size, and color for your labels, and click Next.
4. In this following section, you need to pick the fields that you want to appear on the labels. So, under available fields, click on the ones that you want to transfer to the “Prototype label” section, and click Next.
5. In this step, you need to tell Access how to sort the data to organize it for the labels. Review the options under “Available Fields” and click the field or fields that best organizes the information and these selections will appear under “Sort by.” And click Next.
6. Now, give your file a name and click “See the labels as they will look printed” option to see a preview and click Finish.
7. Finally, you will see a preview of the mailing labels and you will be ready to print them or save the file for future use.

Fantastic! Your labels were created in minutes and this will save you time and effort.