How to print envelopes from the address list

2017-08-24

As a follow - up to the previous article about wedding invitations, I would like to talk about the ways how to print envelopes from the address list in a CSV file.  Let us suppose, you have a list of people's names and their email addresses. You would like to send them letters with invitations to the wedding. Filling a big number of envelopes manually is a time-consuming task. So, how to automate this process? With FastReport you can create labels for envelopes with people's names and addresses. Everything that is needed is to paste the labels on the envelopes and send your letters.

First, we need to form a list of three columns: "Name", "Address" and "Postal code". It is worth doing in an Excel spreadsheet as it is convenient. Then, save the file in CSV format:

 

Now create a new report. We will use the master of labels:

In the label wizard click the "Custom label" button:

Select a paper size - DL envelope:

Set a number of rows and columns to 1. Also, turn on the landscape orientation option and swap the width and height of the label:

Now we have a label template, that can be glued to a standard envelope of the size 110x220mm.

Add a new data source in the report. Mark the option "Field names in the first line":

Next, mark the table with three fields:

 

Create a simple template:

At the top left there is a sender's address. At the bottom of the page on the right there is a recipient's address.

Run the report in preview mode:

In this article we have introduced the procedure of producing labels for the postal envelopes. After these accessible steps one should only print them and send.

April 26, 2023

How to use RFID tags in FastReport .NET

The new page object is an RFID tag in FastReport.NET allows users to use the library to create labels or maps without third-party programs
February 24, 2022

How to print one page of the report in several copies

We are talking about the individual settings for printing your report from our own application with the FastReport .NET library.
October 11, 2021

How to use Gantt charts in FastReport Business Graphics

We will figure out what is it a Gantt chart in FastReport BusinessGraphics. We’ll also learn about functional features and create our diagram from scratch.
Fast Reports
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 66 Canal Center Plaza, Ste 505, Alexandria, VA 22314

© 1998-2024 Fast Reports Inc.