10 things that will totally stuff up your mailing data

Home / 10 things that will totally stuff up your mailing data

Have you ever sent your data list off to a mailing house only to find out it needs 5 hours of data manipulation?


This is a more common problem than you may think because it is the little things that can create a data file from hell. Keep these 10 points in mind next time you export your data and keep your boss and your mailing house happy.

    1. Hiding a row doesn’t delete it. The first thing we do when receiving a data file is to convert it to .TXT. This means any hidden rows will reappear.


    1. Converting also means that any multiple tabs will be lost. Keep all your data on the first tab to make sure it doesn’t get over looked. 100 tabs are not needed!


    1. Adding multiple lines look pretty, but they create all sorts of issues. If your address has two lines, create an Address Line 1 column and Address Line 2 column.


    1. Where   are  all these    spaces   coming  from? Adding spaces at the end of cells means they will show in your address block.


    1. Keep your data up to date. Sending a letter to an address where your customer no longer lives is just straight up costing your business money. Take returned mail and no longer current customers out of your data list.


    1. We love suburbs! Please include them in your mailing list, Aus Post needs them. Yes, this happens more than you think it does.


    1. Formulas are not friends. What ever they are doing in there, it won’t be happening after the file is converted to TXT.


    1. Don’t send us all your customers’ personal information! We uphold strict privacy polices, however it is still unethical to send us their birthdays, phone numbers and how many children they have.


    1. , . ‘ “ “ : ? These characters are disliked by Aus Post’s automatic sorting machines. If an address has a unit number it is best to use / rather than ,


  1. Mailing lists are not a place for notes. John DELETE, Kenwick Store CLOSED or Jane TERRIBLE CUSTOMER are not suitable addresses. This can be a little embarrassing if it ends up in the mail. Make a new column for comments or just delete the entries that are old.


Now that you know what to look for, keep your eye out and clean up that list. Data lists can be huge, so being on top of things will not only save you money, but keep your marketing and communications effective.


Click here to download a sample data list.


Are you planning direct mailer and need a little help? Contact our data expert Brett on 08 9493 0477.


Leave a Comment

Facebook Feed

Write a letter to Santa! 🎅⭐

Australia Post works with Santa to make sure he reads and replies to letters from Australian kids!

Santa enjoys finding out about presents kids would like and stories they have to share.

Simply post your letter to:
North Pole, 9999

⭐ Be sure to include a return address so Santa can respond! ⭐

Track the progress of your letter through the interactive Santa Mail Tracker: auspost.com.au/about-us/corporate-responsibility/education/santa-mail/track-letter

Letters must be posted to Santa no later than Friday 15 December. Christmas is a busy time of year at the North Pole and it may take Santa a little longer to respond to your letter or postcard. Make sure you send your letters and postcards nice and early to ensure you receive his response before the big day!

Australia Post have a range of decorative Christmas letter templates you can edit and send!
Reindeer template: goo.gl/88PVH6
Santa & Mrs Clause template: goo.gl/3yCdTG
Christmas Stockings template: goo.gl/Zw7nEv
Elves template: goo.gl/jBzL4k
... See MoreSee Less

View on Facebook

Everyday, someone in Australia suffers a spinal cord injury. From workplace incidences, to road and water accidents or extreme sports, the event of permanent paralysis is always unexpected and frequently preventable.

PBF Australia (The Paraplegic Benefit Fund) was established to create greater awareness of these risks, with the aim of reducing the impact and incidence of spinal cord injury in Australia. Quickmail are proud to be members of Paraplegic Benefit Fund Australia.

Yesterday Quickmail had a presentation from Symon and Katie. On behalf of the staff at Quickmail, thank you for taking the time to talk to us. Your visit has no doubt left a strong impression with us all and left us thinking of ways to aim to reduce the incidence of serious injury at work, on the road and at play.

Some key statistics surrounding spinal cord injuries include the following:
- 3 spinal cord injuries per week in WA
- Approximately 141 spinal cord injuries per year in WA
- 46% of spinal cord injuries are motor vehicle related
- 34% of spinal cord injuries are from falls
- 11% of spinal cord injuries is an “other” category (i.e. violence, being hit by objects, jerked off a horse, etc.)
- 9% of spinal cord injuries are Aquatic related
- Average age of a spinal cord injury is 43 primarily due to slips, trips and falls but the common age bracket for young adults is 15-24 particularly in males.
... See MoreSee Less

View on Facebook