Printing Address Labels
Last updated
Was this helpful?
Last updated
Was this helpful?
In the tutorial below, we will review how to generate a list of customer addresses from Wise Option which can then be used in a label template to print. We recommend using Microsoft Word to generate the label template.
The tutorial below will guide you through generating the list of addresses from Wise Option to using Microsoft Word's Mailing feature to import the list and merge it into your selected label template.
Estimated Time to Complete – 10 Minutes
For visual learners or those who prefer step-by-step guidance, we offer a concise instructional videos below.
Generating the list from Wise Option
Navigate to Reports > Customer > Address Labels
Select or Create a query to load a list of customers that you would like to print address labels for
Select the customers you would like to print labels for
Select the address type you would like the list to generate with
Click Print
Click Yes when asked to preview
Export the report as a .csv file
Open the file in Excel and add column headers to each column
Printing the list using Microsoft Word Mailings
Open a blank Word document
Navigate to Mailings
Click Start Mail Merge > Label
Select the brand and then product > Save
Click Select Recipients > Use Existing List
Select the .csv file you saved from Wise Option
Save
Place your cursor in the first line of the first label
Click Insert Merge Field and click the corresponding field to build the label template
Once you are happy with the first, click Update labels and Word will update the others
Click Preview Results to ensure you are happy with the labels
Click Finsh & Merge > Print
for a tutroial from Microsoft on how to use this feature.