Debbie Mayo-Smith international inspirational motivational how-to speaker technology, time management, improving business performance
Motivational Speakers, Sales, Marketing, Time Management, Productivity, Technology, Tips

Avoid costly mailing list blunders

Duplicate letters, misspellings, incorrect email addresses can make you look silly, plus they’re wasteful. Before you start your next mass communication, copy your list into Excel, because it’s not just for numbers. You can work database magic en masse.

You can:

• get rid of duplicates

• correct email and address errors

• create targeted emailing lists

• add information not held in your original file.

Most of the tricks are Excel functions which you’ll find by clicking Functions on the Insert menu, or the fx icon. An example of ones you’ll find exceedingly useful are:

• Exact – removes duplicates

• Form – enter information via a form rather than tabbing across

• Trim – removes extra spaces between words

• Proper – corrects tense (with first letter capitalised)

• Concatenate – merges separate columns of information into one (a great way to split names for addressing letters; go to Text to Columns).


This article is copyright to Debbie Mayo-Smith & SuccessIS. You may use it for your newsletter, website or as an article. It can be reproduced - but in its entirety and with inclusion of Debbie Mayo-Smith as the author and the weblink www.successis.co.nz


Share/Bookmark

Free Quick Tips Newsletter
You'll love this succinct monthly tip newsletter focused on improving your business results and productivity.

View and sign up now!!!

Andrew Gardner; Investors Edge

"Get on her email list mate! She sends brilliant tips every month. It’s the one newsletter I love to get!"