How to Create a Vicinity Mailing List & Mailing Labels

13 views
Skip to first unread message

landproDATA

unread,
Jan 25, 2019, 4:53:44 PM1/25/19
to landp...@googlegroups.com

Creating a Vicinity Mailing List:

1. Log into landproDATA.

2. Choose which map you will need, Ada County or Canyon County, by clicking the county map or selecting the county in the left menu.

3. From the Tasks window on the right side of your screen, under SEARCH, choose SUBDIVISIONS.

4. Enter the name of the subdivision you want where it has “*Subdivision:”, as shown to the right. Note: You do not need to enter the word “Subdivision” in the Value box. For example, enter “Castlebury”, not “Castlebury Subdivision”.

Subdivision Search Example.png

5. From the results window, click on the correct subdivision (which will highlight it green) and then click Zoom to Selected.

6. Back on the window showing the map, at the top of the Tasks window, there is a menu titled Tasks List, click on that menu and choose Buffer.

7. Enter the distance around the subdivision that you would like your vicinity list to include (300 ft. is the default) under Buffer Settings.

You can also name that buffer if you would like under Optional Settings.

8. Select Done.

9. Then click on Select Parcels.

10. Then click on View Parcel List.

11. Then click on ‘Output Parcels list to Excel CSV file’.


Example:

Parcels Excel List Example.png

Creating Mailing Labels from your Vicinity List:

Note: Determine ahead of time what labels you have, and how to place them in your printer in order to properly print your labels.)

1. From Excel, you can clean up the list, remove duplicate addresses, delete columns you don’t need, etc.

2. Save and name your file as you find appropriate. Close Excel.

3. Open a new Microsoft Word document.

4. Click on the Mailings tab (essentially you will work your way across these options).

5. Under Start Mail Merge dropdown menu, select ‘Labels…’.

6. A box will pop up.

7. Choose the type of label you have (i.e. Avery US Letter 5161)

8. Under Select Recipients, choose ‘Use Existing List’, then find the Excel spreadsheet you saved above.

9. Under ‘Insert Merge Field’ choose the fields you want displayed on your label (shown to the right) from the drop down menu and format properly for a label.

Choose the fields.png

10. Click on Update Labels.

11. Click on Preview Results (An example is shown below.).

Fields export example.png

12. Place your labels in your printer appropriately.

13. Under Finish and Merge dropdown, select ‘Print Documents’.

Reply all
Reply to author
Forward
0 new messages