{"id":10670,"date":"2009-01-29T09:25:01","date_gmt":"2009-01-29T13:25:01","guid":{"rendered":"http:\/\/www.ewm.com\/internalblog\/?p=10670"},"modified":"2009-01-29T09:25:01","modified_gmt":"2009-01-29T13:25:01","slug":"90-day-challenge-day-xx-tools-you-can-use-mlxchange-export-to-excel-for-mailing-labels-in-word-2003","status":"publish","type":"post","link":"https:\/\/blog.myewm.com\/?p=10670","title":{"rendered":"90 Day Challenge – Day 46 – Tools You Can Use – MLXchange Export To Excel For Mailing Labels In Word 2003"},"content":{"rendered":"

I have had occasional calls from agents who were attempting to print mailing labels directly from MLXchange to Avery 5160 (30 to a page) mailing labels with complaints that, for some unknown reason, the printing was not conforming to the labels, and the labels\u00a0were ruined.<\/p>\n

Mailing marketing materials from Max\u00a0will be covered in a separate post. Generating letters, labels and envelopes in Max is extremely easy; however, you may not want to upload an entire neighborhood to Max just to generate letters, labels and envelopes unless you were tracking that neighborhood in your Max Notes.<\/em><\/p>\n

You have a need to merge the MLXchange tax information with a Word document. You\u00a0want to personalize a letter and\/or create labels and envelopes to advise\u00a0the owners that you have a buyer who\u00a0desires a particular model or view in a their neighborhood.<\/p>\n

The entire steps are in the movie below.\u00a0 Before you get started, you need the following for a proper export to Excel.<\/p>\n

In MLXchange, click on the TAX tab and make sure you are in the right county<\/strong>.\u00a0 Click on the SEARCH MAP tab and select the area\u00a0 by drawing a polygon. Click on RESULTS.<\/p>\n

For Dade, you will have created your RESULTS grid (demonstrated in a prior post<\/a>). Your Dade Results Grid\u00a0may have included the following fields:<\/p>\n

    \n
  1. Owners Name Full (which includes some of the address – this may be a recent glitch)<\/li>\n
  2. Owners First Name<\/li>\n
  3. Owners Last Name<\/li>\n
  4. Owners Company Name (just in case First and Last Name are blank)<\/li>\n
  5. Owners House Number<\/li>\n
  6. Owners Street Directional<\/li>\n
  7. Owners Street Name<\/li>\n
  8. Owners Street Designator<\/li>\n
  9. Owners Unit\/apt Number<\/li>\n
  10. Owners City<\/li>\n
  11. Owners State<\/li>\n
  12. Owners Zip Code<\/li>\n<\/ol>\n

    For Broward, your TAX RESULTS grid contains only three field names:<\/p>\n

      \n
    1. Mailing Label 1<\/li>\n
    2. Mailing Label 3<\/li>\n
    3. Mailing Label 4<\/li>\n<\/ol>\n

      (Mailing Label 2 is not necessary).<\/p>\n

      As you know,\u00a0mailing<\/strong> marketing pieces yourself is not the highest and best use of your time; however, for those times you need this application, the following movie shows you the process from start to finish:<\/p>\n

      <\/span>
      <\/i><\/a><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

      I have had occasional calls from agents who were attempting to print mailing labels directly from MLXchange to Avery 5160 (30 to a page) mailing labels with complaints that, for some unknown reason, the printing was not conforming to the labels, and the labels\u00a0were ruined. Mailing marketing materials from Max\u00a0will be covered in a separate […]<\/p>\n","protected":false},"author":1439,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_expiration-date-status":"","_expiration-date":0,"_expiration-date-type":"","_expiration-date-categories":[],"_expiration-date-options":[]},"categories":[59,105],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.myewm.com\/index.php?rest_route=\/wp\/v2\/posts\/10670"}],"collection":[{"href":"https:\/\/blog.myewm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.myewm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.myewm.com\/index.php?rest_route=\/wp\/v2\/users\/1439"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.myewm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10670"}],"version-history":[{"count":0,"href":"https:\/\/blog.myewm.com\/index.php?rest_route=\/wp\/v2\/posts\/10670\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.myewm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.myewm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.myewm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}