logo
small logo
  • Products
  • Buy
  • Support
  • Articles
  • Customer panel Support
    • en
    • pt
    • es
    • de
    • pl
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • How to print envelopes from the address list
  • How to make wedding invitations from Excel

    August 25, 2017

    Do you have a celebration on the occasion of the wedding? Do you need to

    read more
  • How to use Gantt charts in FastReport Business Graphics

    October 11, 2021

    An interesting type of charts, the Gantt chart, appeared with the release of FastReport

    read more
  • How to use Online Designer in ASP .NET Core

    January 17, 2018

    One of the novelties by FastReport .NET 2018 was the adaptation of OnlineDesigner to the

    read more
  • How to use WebReport with ASP .NET Web Core application

    January 17, 2018

    Recently FastReport introduced a new library under the .NET - FastReport Core platform. This is

    read more
  • Copying the Bands from One Report to Another with All the Contents

    March 31, 2021

    Sometimes there is a need to use parts of one report in another. In simple

    read more

How to print envelopes from the address list

August 24, 2017

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.

about product download buy
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
.NET FastReport Desktop CSV

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Buy
  • Download
  • Documentation
  • Testimonials
  • How to uninstall
  • Ticket system
  • FAQ
  • Tutorial Video
  • Forum
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Contact us

© 1998-2022 by Fast Reports Inc.

  • Privacy Policy