top of page

How to Set Up Data for a Direct Mail Campaign.

Direct mail advertising involves sending a physical piece of mail to a potential customer. Direct mail offers several advantages over other forms of marketing, such as targeting a specific audience and the ability to track results. Additionally, a direct mail piece can be more personalized than other types of advertising, which can help to increase response rates.

Many major brands utilise direct mail as a successful channel in their overall marketing strategy. By sending existing and potential new customers personalised pieces through the mail they help to strengthen their relationships with their customers, while also increasing the likelihood of growing sales.

Step 1. To personalise a campaign or to address an envelope, you first require data!

Gather a solid database of customers or potential customers from a source. ‍Setting up a direct mail campaign starts with a great database of existing and potential customers to reach. You can either export data from your CRM system or purchase a database from a credible source.

Note - Beware when looking at this option. Many databases purchased can be out of date and not relevant to your target market!

Step 2. Once your data is exported successfully into Excel, sort your data into the correct fields.

Here is an Example of an Excel spreadsheet with the fields correctly laid out for an Addressed Envelope mail out.

The Customer Number field is not a mandatory field for a campaign mail out, however it does make it easier to delete any envelopes that end up Returned to Sender by Australia Post. Removing returned items from your data is good practice, as it keeps your data source clean. You do not want to keep paying to send marketing offers to someone who has moved from the address you have on record!

Once your data is supplied to Printcraft for a campaign, our specialised software will dedupe - remove duplicate addresses, remove any contacts that have critical fields missing (ie. Suburb) and return your data to you with a final campaign quantity. We then provide you the opportunity to review and approve this cleaned data before we move forward with your campaign.

Below is the Australia Post Guide to correctly addressing Envelopes.

Printcraft’s software takes the above Excel Spreadsheet and populates the envelope to the below specifications, adding the barcode required to maximise any bulk discounts (over 300 items).

(Australia Post Guide to address layout)

Step 3. Set up your Artwork for Personalisation in Print

When personalising a mail piece, artwork will be set up with a placeholder in the position of the data space. Ideally, this is set up with Column names to easily identify which column of data is inserted into each place holder. You can even include data such as a personalised discount amount for each customer, like the example below.

Example #1 - DL Flyer Personalised with Name and Percentage Discount.

Here we demonstrate the use of only two columns (First Name – Column B, and Discount – Column I), which could be used to personalise a DL piece inside your envelope or the back of a Self-Mailer.

(Image above: Data placeholders set up in artwork)
(Image above: Personalised data inserted)

Example #2 - Envelope / Flysheet set up with Customer Number, Name & Address.

Here is an example of how your data would be set up and then inserted onto the front of Envelopes, Flysheets or Self-Mailers. Instead of inserting “First Name”, “Last Name” etc, we use the Column names to avoid any confusion.

(Image above: Data placeholders set up in artwork)
(Image above: Personalised data inserted)

Need more help? Just give our friendly team a call to discuss your next mail campaign. We can help each step of the way, and provide advice and guidance when needed.

We're here to help make Print & Mail easy and stress-free!

216 views4 comments

Recent Posts

See All


Jose daniel
Jose daniel
5 days ago

Looking to jet off to an exciting destination without breaking the bank? Finding cheap flights to anywhere is easier than you might think! Here are some tips to help you score the best deals and turn your travel dreams into reality:


Be Flexible with Your Travel Dates: Being open to traveling on weekdays or during off-peak seasons can often result in significant savings. Use flexible date search options on flight booking 1+866-201-5842 number to compare prices across different dates.


Set Price Alerts: Take advantage of price alert tools offered by various travel websites and apps. Simply set your desired destination and price range, and you'll receive notifications when prices drop, allowing you to snag the best deals.


Use Airline Miles…


Many students believe that healthcare law writing is difficult. However, you must consider this a challenge rather than a burden. The majority of students who seek help with their healthcare law assignments face the same issues that they would face when writing a paper. A healthcare law paper is essentially an academic document that suggests a candidate's ability to complete independent assignments. Assignment Help from provides perfect assignment compositions that ensure the highest grades at very cost-effective rates. Our Health Care Law Assignment Help has consistently provided precise and great online health care law assignment help to a large number of students within the specified time frame.

Today, you will learn why students become frustrated while completing a healthcare law assignment help.…


Thank you for this insightful article! Join our pay someone take my online class in the USA and get on the path to a successful future.


Do you need Mobile App Development Assignment Help? Our knowledgeable mobile app development tutors are here to help. We can assist you with all facets of your development coursework, ranging from fundamental ideas to more complex subjects. From proofreading and editing to assignment writing services, we provide a comprehensive range of services. Get going now to earn the grades you merit!

bottom of page