logo
small logo
  • Products
  • Buy
  • Support
  • Articles
  • Forgot password?
    • en
    • ru
    • pt
    • es
    • 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 merge several csv files into one

    August 29, 2017

    This article aims to provide the insight into how to use FastReport.Net to merge two

    read more
  • How to build daily graphics from csv files

    August 24, 2017

    Suppose you keep a record of employee sales in an Excel file. Would you like

    read more
  • How to make a csv file conversion: remove columns, sort, filter

    August 24, 2017

    MS Excel spreadsheet editor handles editing CSV files perfectly. You can sort and filter data,

    read more
  • How to make a PDF document from a text file

    August 25, 2017

    Today we will talk about the cases when you need to make a PDF document,

    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
Head of QA
.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
  • Our team
  • Contact us

© 1998-2021 by Fast Reports Inc.

  • Privacy Policy