{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/0c0a3efb059745879c572b35bb51137b\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/0c0a3efb059745879c572b35bb51137b-029b778c9eec0414.gif","duration":172.118,"title":"Extracting and Formatting Mailing List Data in Scarlett","description":"In this video, I walk you through the process of extracting data from Scarlett to create a mailing list, specifically for sending out holiday cards. I demonstrate how to filter for Scarlett mortgage deals assigned to Scarlett training, ensuring that only the applicant's names and mailing addresses are included in the export. After exporting to Excel, I introduce our address formatter tool, which organizes the data into separate columns for easy label creation. Please make sure to enable macros when using the formatter to avoid any errors. I encourage you to follow these steps to streamline your mailing list preparation."}