How do I create mail or mailing labels using Reports in Access 2007? First of all have your report created where you want to generate labels with i.e. First Name, Last Name, Address, City, State, Zip etc., and then on the Ribbon click the Create Tab, go to the Reports group and click Labels button and follow the step in the short wizard on setting up you labels and the fields you want to include, or not include into your label report. Your report can be on anything, just as long as again you have the fields in the report you want to pull and add to your labels. Once you finish the wizard you may want to print the labels on a paper first to see if aligned correctly.

Purchase the training video and you can see this in action for yourself!