Hello, Taglotn.
The steps provided by my colleague are for QuickBooks Desktop, that's why you're unable to see the File option on your end since you're using QuickBooks Online.
However, as a workaround, for printing labels from QuickBooks online, you need first to export your report file into an Excel file. After that, if you wish to edit your exported Excel Spreadsheet, then you can modify it as you require. Once the editing is done, click the Save As option in the File tab.
Here's how:
- Go to Reports.
- In the Search field at the upper right, choose a report.
- On the upper right, select Customize, then Rows/Columns.
- Select Change columns.
- Mark your Full Name and any applicable address information you need, then Run Report.
- Choose the Export icon.
- Click Export to Excel.
Then, we can modify the MS Excel file.
Here's how:
- Open the Excel file.
- Delete all header rows from the spreadsheet. Make sure not to delete the column headings.
- Delete any extra leading columns to the left of the Full Name column.
- Make sure both Full Name and Billing Address are populated with data for each customer.
- Go to the File tab, then Save As.
Once completed, you can create a mail merge template in MS Word. Check Microsoft Office's website, they provide a step-by-step guide that will make it easy for you to set up your template. You can also refer to this article: How to create a mailing list using the mail merge feature of MS Word for further guidance.
Though, I can see the convenience of having the print label function. However, this feature is currently unavailable. I recommend sending your feedback so our developers can consider adding this option in the future. To do so, please follow the steps below:
- Click the Gear icon in the upper-right corner.
- Select Feedback under Profile.
- Share your feedback.
- Tap Next to submit.
Please know you can always come to the Community for your QuickBooks needs. I'll be here as soon as I can. Have a great day!
