How to Print Vendor Labels with OData and Microsoft Word

To access Vendor data via OData, use the following URL format:

https://sbconnect.softbasesystems.com/(your company name)connect/dataaccess/vendor

If needed, visit How to Use OData with Excel for steps.

Once Vendor data has been loaded, save the Excel document to your device.

Follow the steps below to create and print Vendor Labels using the Vendor information collected via OData.

1. Open Microsoft Word.

2. Use Mail Merge to merge the data from Excel to Word.

1. Open Microsoft Word and create a blank document.
   
2. Click the Mailings Tab.
   
3. Click Start Mail Merge.
   
4. Click Labels; Label Options window will appear.
   
5. Select Page Printers under Printer Information.
   
6. Select Avery US Letter under Label Information.
   Select 5160 Address Labels for Product number.
   
7. Click OK.
   
8. Click Select Recipients.
   
9. Select Use an Existing List
10. Select the Excel file you saved to your device and click Open.
    
11. Select the Excel worksheet that contains your data and click OK.

3. Insert Address Block Merge Field.

1. Click the Address Block button in the Mailings tab.
2. In the Insert Address Block window, click the Match Fields button.
3. Make sure the fields match and click OK.
4. You will return to the Insert Address Block window. Click OK.
5. Click the Update Labels button to pull the information from the recipient list into the labels.

4. Finish & Merge

1. Click the Finish & Merge button in the Mailings tab.
2. Select the Edit Individual Documents option.
3. Select All to merge all records and click OK.

4. Optional - Add Borders (for ease of cutting)

1. Click + icon on upper-left side of the table to select the entire table.
2. Click the Border icon from the menu and click All Borders from the options.

... and you're ready to print your Vendor Labels!