

#FASTEST WAY TO CLEAN EMAIL CODE#
It took me the better part of 20 minutes, but it was just the same three key/mouse strokes over and over again (~200 times actually) and overall pretty painless. What this code allows you to do is circumvent testing (ie looping) each individual cell and handling trimming (removing leading and ending spaces) and cleaning (removing unprintable characters) process for your Excel data.

Delete All Emails from Senders You Don’t Care About 4. Quickly scan the 50 selected unread emails for addresses that you don’t want to block, (PTA, local wine shop, your mum-maybe) and deselect/uncheck those so you don’t block them.Ĭlick on the “Spam” Icon In the menu bar and when the action screen pops up click on “Mark As Spam and Unsubscribe”. Another Spring Cleaning Your Email Marketing Program Post 1. Block Unwanted Senders and Unsubscribe from Marketing Emails 3. (It will select the 50 Unread emails on the screen)

In the upper left hand corner use the drop down menu on the top “check box” to select “Unread” email. In the upper right hand corner select the maximum email to be viewed at one time. Set my Inbox “View” to Unread/Read instead of traditional inbox view. In the Filters section, configure the appropriate filters: To segment contacts whove never opened one of your emails, select Contact property > Last marketing email open date. In the top left, click the pencil icon edit and enter a name for the list. For Gmail: I had about 10,000 unread spam in my inbox about three weeks ago and was getting about 40+ spams a day. In your HubSpot account, navigate to Contacts > Lists.
