Product
-
JurisĀ®
Category
-
Product Features
Was this helpful?
Thank You!
There was an error with your submission. Please try again.
Article Content
Option #1: Create an Address List/Mailing List of Clients/Matters or Vendors in Excel:
- Open Juris Supplemental Reports in Microsoft Access.
- Click Queries from the Objects List.
- Double-click ClientMatterNamesW/Addresses to open an Access Document with the mailing list data.
Note: Alternatively, the Vendor Payments report in Supplemental Reports can be used to retrieve Vendor addresses. The report can be saved to Excel. - Press CTRL A on your keyboard to highlight the entire document.
- Press CTRL C on your keyboard to copy.
- Click File and select Exit to close Microsoft Access.
- Click the Windows Start button.
- Click Programs and select Microsoft Office.
- Click Microsoft Excel to open Microsoft Excel.
- Click cell A1 in the Excel spreadsheet.
- Press CTRL V on your keyboard to paste the document.
- Delete any columns you want to remove and resize any columns you want to change.
- Click File and select Save to save the Excel spreadsheet.
Option #2: Print mailing labels from within MS Access:
- Open Juris Supplemental Reports in Microsoft Access.
- Click Queries from the Objects List.
- Double-click ClientMatterNamesW/Addresses to open an Access Document with the mailing list data.
- Access 2003: From the toolbar, click Reports, then click New. Select Label Wizard, then select the query to be used for the labels. Click OK.
- Access 2007 & Newer: Select the Create tab, then click the Labels icon in the toolbar. This will open up the Label Wizard and then you can continue with the steps below.
- Choose the type of label that will be used. The options include different manufacturers as well as what style label. After the selection has been made, click Next.
- Select the font, size, etc. that will be used on the labels.
- Now choose how the label is to be set up. Highlight the area to the left that lists the available fields, then click the > button. Any spaces or commas that are to appear in the label must also be entered manually. To start a second line, press Enter. Use the arrow keys to maneuver between fields and lines. Click Next once the label is set up as desired.
- Make any sort selections as needed. Click Next when complete.
- Name the label report, then click Finish.
- The labels will now appear if the selection was made to see the labels as they will look printed.