A personalized mailer starts as a spreadsheet. Before anyone argues about stock or folds, the thing that decides whether the job prints on schedule is the data file you hand over, and what is inside it.
Here is the short answer. Send one spreadsheet: one row per recipient, one column for every detail that changes from piece to piece, the same column names used all the way down, and a complete mailing address in every row. That file is what makes a personalized postcard or letter possible. Everything below is what each column does once the job reaches the press, what a messy list costs you, and where variable data sits in the rest of a Wilmington direct mail job.
Key takeaways
- The file is a spreadsheet with one row per recipient and one column per varying field. Consistent field names matter more than anything else in it.
- Every row needs a complete, deliverable address in separate columns. Addressing and postal sorting read those fields, not a single address blob.
- Decide what prints when a cell is empty before the proof, not after. A blank first name has to become something.
- Variable data needs a list, so the audience decision comes before the data file.
- Linprint prints, personalizes, addresses, sorts and prepares the mailing from one shop on Market Street in Wilmington, and nothing goes on press until you approve a digital proof.
The file is a spreadsheet with one row per recipient
Variable data printing means each printed piece can carry different content while the job runs as one production job. The press needs to be told what changes, for whom, and in what order. A spreadsheet is how you say that.
One row is one recipient and one printed piece. Each column is one thing that varies: a first name, a company, a street address, an offer, a code, a store location. The header row names those columns, and the template on press is built against those names. If the header says FirstName, the piece asks for FirstName. If half the file says First Name instead, that is a second field as far as the template is concerned, and it prints empty.
So the file is boring by design. One sheet. One header row. No merged cells, no color-coded notes, no second tab with the real version, no hidden rows left over from filtering. Export what you want mailed, not the working file you have been editing since March.
What variable data changes on the printed piece
Linprint’s direct mail page lists what personalization covers: names, offers, images, codes, locations and segmented content, all built from the campaign data you supply. In practice that is six different jobs for six different columns.
Personalization types as listed on linprint.com/direct-mail/, read 7 November 2026.
Two of those six are worth more than the rest. A code that belongs to one recipient tells you which mailing produced the call, which is the only reliable way to know the piece worked. And a location column makes a regional mailing feel local: the same postcard sends a Wilmington household to the Wilmington address and a Leland household to the one they will actually drive to.
Four things a usable mailing file has
A file either runs or it comes back with questions. These four are what separate the two.
One row per recipient. Not one row per household with two names in it, unless you want one piece addressed to both. Two rows for the same person produce two pieces and two postage charges.
One column per varying field. If the offer changes by segment, that is a column. An instruction in an email — “the plumbers get the second offer” — is not something a press can read.
Field names that never change. One spelling per column, no trailing spaces, no renaming halfway through the project. If you add a field after the template is built, say so, because the template has to be changed to use it.
A deliverable address, split into its parts. Street in one column, unit or suite in its own, then city, state and ZIP separately. List processing, addressing and sorting all work off those fields. One cell containing an entire address as free text is a cleanup job before it is a mailing.
Numbers, dates and codes are where files quietly break
The most common damage to a mailing file is done by the spreadsheet itself, before anyone sends it. Four to check:
- ZIP codes losing a leading zero. Wilmington ZIPs start with a 2 and survive, but any out-of-state record beginning with a zero does not: stored as a number, 07030 becomes 7030. Format the column as text.
- Promo codes read as numbers. A long numeric code becomes scientific notation, and a code starting with zero loses it. Same fix.
- Dates reformatting themselves. If a date prints on the piece — an appointment, an expiry, a renewal — decide the format you want and store it as text in that exact form.
- Mixed capitals. A column of names typed as JANE, jane and Jane prints exactly that way. Fix case in the file, not on press.
Then read the last rows of the file for a minute. Blank rows at the end, a stray total row, a note to yourself in row 400: all of it becomes a printed piece if nobody catches it.
Decide what prints when a cell is empty
Some rows will be missing something. A first name you never collected, a company on a consumer record, an offer field left blank. The piece still has to print, so every variable field needs a rule for the empty case. There are three sensible ones:
- Print a fallback — “Neighbor”, “Friend”, your own default line — and keep the record in the mailing.
- Drop the line entirely, so the layout closes up instead of printing a hanging greeting.
- Hold the record out of this mailing and fix it before the next one.
Pick one per field and say it when you ask for pricing. This is the single most common reason a personalized proof comes back looking wrong, and it takes one sentence to prevent.
Variable data needs a list, so settle the audience first
Personalization is only possible for information you hold. If you do not have names and addresses, there is nothing to personalize against. That is the real difference between a targeted mailing and saturating postal routes: Every Door Direct Mail reaches chosen routes without buying a list, and without a list there is no name, no company and no per-recipient code to print.
So the audience question comes first, and it is covered on its own in EDDM or a mailing list: which direct mail approach fits your Wilmington, NC business. Settle that, then build the file. If you do not have a list yet, the direct mail page says the useful thing: start anyway, because that is a solvable problem. Tell Linprint who you are trying to reach and the conversation starts there.
Format is a separate decision from personalization
Variable data works on a postcard, a self-mailer or a letter in an envelope. Each gives personalization a different amount of room. A postcard carries a name and an offer well and runs out of space quickly. A letter has the space for a paragraph that refers to the recipient’s own situation, and envelopes, reply devices and inserts can be coordinated with it. Linprint produces all three, plus envelope printing in-house.
Choose the format on what you want the reader to do, which is worked through in postcard, self-mailer or letter in an envelope. Then decide how much of it varies. Doing it the other way round — writing a long personalized paragraph and then discovering it has to fit a postcard — is how copy gets cut badly late in the week.
Count your versions before you quote
“Number of versions and personalization needs” is one of the six things Linprint’s direct mail FAQ asks for on a quote, and it is the item people answer loosely. A version is a distinct layout or distinct copy, not a changing field. One postcard with a name and a code on every piece is one version. Three different offers for three segments, each with its own image and headline, is three versions — three sets of copy to write, three to proof, one mailing.
Count them honestly. Versions are the part of a personalized job that takes real time on your side, because every one of them is something a person has to read and approve.
Where the data file sits in the production workflow
Linprint runs a direct mail job in three steps, and the file belongs to the first two.
01 Define the audience. Who should receive the piece, what you want them to do, the quantity, the geography, the timing and the goal. The data file is the written form of this step.
02 Build and approve. Format, dimensions, stock, folds, personalization and mailing requirements are aligned before production, so the piece is built with the postal requirements in mind rather than discovering a conflict after it is printed.
03 Print, address and mail. After you approve the proof, the job is printed, addressed, sorted and delivered to the post office. Addressing and postal preparation — list processing, addressing, sorting, indicia, bundling, documentation and mailing coordination — are part of the same production job in the same Wilmington shop.
The practical effect for you is one team for the piece, the data and the mail date, on one purchase order. Linprint’s production floor runs Ricoh Pro C9500, C9200 and C7100 digital presses, which is what allows one run to produce pieces that are not identical.
The proof is where you check the data, not only the design
Nothing goes on press at Linprint until you have seen a digital proof and approved it. On a personalized job, use that proof for the data as much as the layout, and ask to see the awkward records rather than the tidy one:
- the longest name and the longest company in the file;
- a record with an empty optional field, to check your fallback rule works;
- an address with a unit or suite number;
- one record from each version or segment;
- a hyphenated or two-part surname, and one with an apostrophe.
If those five print correctly, the rest of the file will behave. Approving quickly also matters: the production window starts when the proof is approved, not when the job was quoted. Turnaround times for every service sets out what moves a date and what does not.
What to send when you ask for a quote
The direct mail page asks for six things on a mailing quote. For a variable data job, send all six and one extra:
- quantity and the target mail date;
- format and dimensions — postcard, self-mailer, letter;
- number of versions and what is personalized;
- paper or stock preference, if you have one;
- list status: you have a list, you need help with one, or you want EDDM;
- artwork status;
- and the column headers from your file, even as a screenshot. It is the fastest way to find a missing field while it is still cheap to fix.
The quote request is read by a person, you get a reply within one business day, there is no obligation to order, and a digital proof comes before production. If you would rather talk it through, the shop is at 3405 Market Street #2 and the number is (910) 763-5103, Monday to Thursday 8 AM to 4 PM and Friday 8 AM to 2 PM.
Getting the files there
Artwork and production files go through the secure file upload page, which encrypts files in transit. Three things make that go smoothly: use the same email address attached to your quote, give files names that identify your company and the project, and remember that uploading a file does not confirm an order or a production date — a person follows up. If the upload page gives you trouble, the page itself says to email the files to info@linprint.com or call the shop and they will find another route.
Your mailing list carries your customers’ names and addresses, so ask where to send it when you request the quote rather than guessing. Artwork preparation has its own rules, and how to prepare your artwork files for printing covers bleed, resolution and fonts for the printed side of the piece. Stock choice is worked through in how to choose the right paper stock.
Variable data printing FAQs
Can you personalize an image, or only text?
Images are on the list. Linprint’s direct mail page names personalized names, offers, images, codes, locations and segmented content, all driven by the data you supply. Which image prints is selected by a column in your file, the same way the offer copy is.
Do I need the finished list before I can get a quote?
No. Send the quantity, the format, the mail date and your list status — you have a list, you need help with one, or you want EDDM — and the quote can be built from that. The file itself is needed before production, not before pricing.
What if my list is in three places?
Consolidate it into one sheet before you send it, and de-duplicate while you do. Merging two exports with different column names is the most common source of blank fields on a personalized piece, and it is much easier to fix in a spreadsheet than on a proof.
Will every piece look different on the proof?
A proof shows the layout with real records in it. Ask for several, chosen to stress the longest and emptiest fields in your file, plus one for each version you are printing. Approve the data and the design together.
Does personalization change the format I can mail?
No. Postcards, self-mailers, letters and envelope packages can all carry variable content. The format changes how much room the personalized copy has, which is a design decision rather than a production limit.
Can a mailing be personalized by location without customer names?
Only if you hold something that identifies the location for each recipient — a ZIP, a route or a store column in your file. Personalization is always built from data you supply, so with no list there is nothing to key it to.
Send the list, the format and the drop date
If the campaign is approved and the list exists, the next move is small: send the quantity, the format, the mail date, the number of versions and your column headers to Linprint’s quote request, or call (910) 763-5103. The printing, the personalization, the addressing, the sorting and the handoff to the post office are one job from one shop that has been printing for Wilmington businesses on Market Street since 1947. Other printed pieces for the same campaign — the brochures, letterhead and business cards that follow a mailer — can sit on the same purchase order.
