

From there, I want the FirstName, LastName, Country, Address, let's scroll down here, grab the State, and PostalCode fields. I'm gonna add in the Guests table, and close the Show Table window. To do that, we'll create a new query in Design View. Just like with our other reports, though, we'll first need to identify the people that we want mailing labels for. When you're doing your next mailing campaign or setting up your billing notices, you can generate the labels you need in no time. When writing a new message, click More options in the bottom right corner of the compose window, click Label, and then select one of your labels.- Access makes it easy to generate a report that's perfect for printing out mailing label sheets.You can also click and drag a label from the left side, and drop it on the message.



Create a label Here's how to create a label that you can add to any of your messages: Only you can see your labels, so whether you mark a message with "Best friend" or "Read later," the sender will never know. Labels do all the work that folders do, but with an added bonus: you can add more than one to a message. Labels help you organize your messages into categories - work, family, to do, read later, jokes, recipes, any category you want.
