Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWelcome to Community, @Juneauyachtclub2013.
While we're unable to export customer addresses in Avery mailing label, you'll want to edit it from MS Word. Let me walk you through how.
After exporting, open the Excel file and delete all header rows from the spreadsheet. Make sure not to delete the column headings. Then, review all records (rows) to make sure both Full Name and Billing Address are populated with data for each customer. From there, go to the File tab and then Save As.
Once done, create a mail merge template in MS Word (visit Microsoft Office's website for detailed instructions) and change the font to Avery format. Please check out this article for the step-by-step guide: How to create a mailing list using the Contact List report.
If you need help with other tasks in QBO, you can browse for specific topics here and look for responses that fit your concern.
Keep me posted if you still have questions or concerns with customer topics. I'm always here to help. Take care and have a great day ahead.
Thank you, thank you, it worked just fine and I didn't have to handwrite 200 envelopes. Whew
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.