How To Create An Envelope Report
This tutorial demonstrates how to use the @RECT function of Collect!'s report writer to format
address information for printing on letters to be sent in windowed envelopes. This information may
be applied to any kind of windowed envelope. You can also use it for printing directly on envelopes.
This should help you expedite the mailing of large numbers of letters.
Address Information Displayed In A Windowed Envelope
The @RECT command is a powerful formatting tool for both text and graphics within the Collect! report
writer. One of the most common and practical uses of this command is to print large blocks of text
aligned to an exact page position. In this tutorial, we are going to create two address blocks in
a debtor letter so that they are aligned correctly for a windowed envelope.
We will use the @RECT command to position the company mailing details in a small window on the upper
left corner of the page and the debtor's mailing information in a slightly larger window to the lower
right of the first.
Please refer to the Help topic How To Use The Report Writer Commands for information on how to use
the @RECT command.
Planning Your Report
Now that we have explored the practical uses and technical aspects of the @RECT command, we can
prepare to use it in a report. Before beginning to design the report, we will do a mock-up of the
letter you plan to print.
Mock-up Letter
Take a piece of paper of the same size and dimensions as the letter you will be designing. Draw a
rectangular box, with a pen or pencil, exactly where you want the address information to be
displayed. Draw a smaller rectangle for the return address window, if there is one. To be sure that
the positions are right, fold up the mock letter and place it in one of the envelopes you will be
using. Will the addresses be visible through the envelope windows, if they are printed in the
rectangles you drew? If not, make whatever adjustments are necessary to the rectangles in your
mock-up so that they fall perfectly within the window areas of your envelope.
Finally, draw a line where you folded your letter to fit it into the envelope.
If you take the time to map out every part of your letter in this way, you will save valuable
time when you design your report. With this mock-up accurately prepared and measured, you are
spared the frustration of repeatedly changing and tweaking the dimensions in your report.
You may want to tweak your final report just a little, to get an absolutely perfect, professional
looking letter.
Measuring Values for the @RECT Command
Now that your mock-up is completed, we are going to take the measurements of the rectangles so that
we can use them in the @RECT command.
Here is an example of the measurements you will need:
Address Position Measurements
To obtain these measurements, for each rectangle:
- Measure the distance from the upper left hand corner of the rectangle (marked with the red
dot in the screen shot) to the LEFT side of the paper. This is the LEFT value. For example,
LEFT = .25 inches. Jot down this value next to the rectangle that you are measuring.
- Measure the distance from the upper left hand corner of the rectangle (marked with the red
dot in the screen shot) to the TOP of the paper. This is the TOP value. For example,
TOP = .20 inches. Jot down this value next to the rectangle that you are measuring.
- Measure the distance across each block, the HEIGHT and WIDTH. Write these values on your
mock-up, next to the rectangle you are measuring. For example, HEIGHT =1 .00 inches,
WIDTH = 2.00 inches.
- The @RECT command uses values in measured in 1/100ths of an inch. So, we multiply each of the
measurements by 100 to get the measurement units used by the report writer. So two inches
becomes two hundred units. For example, LEFT = .25 inches x 100 = 25 units; TOP = .20 inches x
100 =20 units, and so on.
Jot these calculations down on your mock-up so that each measurement is converted into 1/100ths of
an inch. Keep this handy while writing the report!
Measuring Position of the Fold Line
Measure the distance from the top of the page to the line that you drew to mark where you have to
fold your letter. Multiply this by 100 to give you the units used by the report writer. For example,
TOP TO FOLD = 3.75 inches x 100 = 375 units.
If you are printing directly onto your envelopes, measure your two address blocks on a
mock-up envelope, but you don't need to mark or measure a fold line.
Creating The Report
Now that you have your report planned and formatted, it is time to open the report writer and type
in the codes necessary to turn this concept into a finished document.
- Sign into Collect! and stop at the Main Menu.
- From the top menu bar, select Print and then select Edit Reports from the drop-down choices.
This will bring up the list of all the reports in Collect!
- Select the NEW button at the bottom of the Report Definition list. This will open a blank
Report Definition.
- Select the field labeled Name and enter a name which is meaningful to you,
for example, "Windowed Debtor Letter Template."
- Select the field labeled Start on and then select Debtor from the list that
appears.
- Select the OPTIONS button in the lower left hand corner of the window. This will bring display
the Report Options form.
- Select the down arrow next to the field labeled Destination and then select
Printer from the pick list that appears.
- Select the field labeled Printer initialization codes and enter:
@*PH
- Select the field labeled Printer termination codes and enter:
@HP*
- Press F8 to save your settings and close the Report Options form.
You can enter multiple Printer Control Codes in to the Initialization and Termination fields.
These codes will reset the printer (*), set the page orientation to portrait (P), and the
font to Letter Body (H).
So for a brief recap, we have now created an empty report called "Windowed Debtor Letter Template"
(or whatever name you chose). It will be taking information from a supplied Debtor record, and it
will print to your printer in Portrait format, in Times New Roman font, size 18.
Entering The Report Codes
Now for the nitty gritty. We are going to enter the individual codes that tell the report writer
how to format the report and what information to print.
The report will proceed in two series of @RECT statements, four in total, which will form the two
boxes. One box will contain the company information and the second box will contain the debtor
information.
After the two boxes, we will draw a line to indicate where the letter should be folded to fit into
your windowed envelope.
Here is a list of the database codes used in this report:
@cd.na - Form: Company Details, Field: Name
@cd.ad - Form: Company Details, Field: Address Line 1
@cd.a2 - Form: Company Details, Field: Address Line 2
@cd.a3 - Form: Company Details, Field: Address Line 3
@de.na - Form: Debtor, Field: Name
@de.ad - Form: Debtor, Field: Address
@de.a1 - Form: Debtor, Field: Address Line 2
@de.ci - Form: Debtor, Field: City
@de.st - Form: Debtor, Field: State
@de.zi - Form: Debtor, Field: Zip
Here is a list of the report commands used in this report:
@RECT
The rectangle command, as explained above.
@Line
The line command, which draws a line across the page from one point to another, indicating the fold
line. This is optional, if you are printing directly onto your envelopes, ignore this command.
You should be looking at the Report Definition for the your "Windowed Debtor Letter Template" report.
Select the Report Body and let's start entering those codes!
- Begin with an @RECT command.
This will begin your first box. Use the measurements you took earlier and feed them into the command
in the order listed above. (To recap, it was left, top, width, height). For the last two values,
enter 0 and 1 respectively. This should yield the following line.
@RECT(left,top,width,height,0,1)
Where left, top, width, and height correspond to your measured values, in 1/100ths of an inch.
- Next we are going to print the Company Name in bold, followed by the mailing address, followed
by the city, state, and postal code.
@cd.na<
@cd.ad<
@cd.ci<, @cd.st< @cd.zi<
This assumes that your Company Details have been entered correctly, that the first line of your
address is your street address, that the second line is your city and state, and that the third
line is your zip code. The @! code turns the bold text option on and off, while
the < symbol trims trailing spaces at the end of fields.
- Now, close the rectangle with another @RECT command.
@RECT
This completes our first box, for company details.
Now begin another box using the measurements you took earlier, for the debtor information.
- Type another @RECT command into your report body.
@RECT(left,top,width,height,0,1)
Where left, top, width, and height correspond to the values you measured for your second rectangle,
in 1/100ths of an inch.
- Next, enter the debtor information, as shown below.
@de.na<
@de.ad< @de.a1<
@de.ci<, @de.st<, @de.zi<
This assumes that the Debtor form has been completely filled out, including all the above fields.
- Now close that box with another @RECT command.
@RECT
This completes the second box.
All that remains is to draw the line showing where to fold the letter. The placement of this line
depends on the size of envelope you are using. You can fold your mock-up and fit it into the envelope
so that you know the ideal placement for the fold line. This should be equal to the height of the
envelope. Ideally, the fold line should run the length of the page. Printers usually don't print
all the way across the whole page, or starting directly at the top of the paper. So you should
subtract around a quarter of an inch (25 units) from your measurements.
For example, when using 8.5"x11" paper with a 9.5"x4" envelope (standard letter size paper with a
standard letter size envelope), the first endpoint of the line should be located at the coordinates
0, 375. This means, start right at the left edge and 3.75 inches from the top of the page. The second
endpoint is at the coordinates 800, 375. That means, the line is 8 inches long, ending near the right
edge of the paper, also 3.75 inches from the top of the page. (This allows for 8.5"x11" paper with
0.25 inches off each margin.)
So the line command would look like this:
@Line(0,375,800,375,1,1)
The last two values set the width to 1 pixel and the style to 1,
which is the value for a dashed line.
Altogether your codes should be similar the snippet shown below.
@RECT(20,25,175,75,0,1)
@cd.na<
@cd.ad<
@cd.ci<, @cd.st< @cd.zi<
@RECT
@RECT(l300,225,300,200,0,1)
@de.na
@de.ad< @de.a1<
@de.ci<, @de.st<, @de.zi<
@RECT
@Line(0,375,800,375,1,1)
Sample values are shown above for the @RECT (left, top, width and height) arguments. Notice
how these relate to the measurements taken earlier. Remember that the last two arguments,
0 and 1, mean no "border" and "clip."
Address Position Measurements
You have completed the part of your report that will display the debtor and company information
visible through the windowed envelopes. For the body of your letter, you may type your standard
first notice or whatever information you would like to convey to your debtors. Now that this segment
of the letter is completed you may copy and paste it into whatever other letters you wish, saving
yourself further time in the long run, when dealing with a series of similar letters.
In addition, by replacing the information inside the boxes, with client information for example,
you can preserve the same formatting for your client letters, as well.
Furthermore, you have just learned a powerful formatting technique that can be used to help you
position text and graphics in any number of ways. This enables you to develop flexible and
professional looking letters and reports that will impress clients and let your debtors know you
mean business.
Mail Merge Alternative
With modern printers, the above methodology may not work as you may get warnings about the page
size not matching.
A more elegant solution would be to use Mail Merge with Microsoft Word.
- Create a report that exports the address block information into a CSV. Your design could be
based on a tagged list or it could loop through the in-progress letter contacts.
- Create a Sample CSV file and place it in the Collect\bin\styles folder.
- Create a Microsoft Word mail merge envelope template and link it to the CSV.
When linking the template to the CSV, use the same path that everyone will use so it can be
opened by anyone. Examples: S:\bin\styles\envelope.csv or \\server\Collect\bin\styles\envelope.csv
- Save the template in the Collect\bin\styles folder.
- In the Collect! report, go to the Report Options and set the following:
- Destination = Other
- Redirect to = Examples: S:\bin\styles\envelope.docx
or \\server\Collect\bin\styles\envelope.docx
|
Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.
Please click this link to send us your comments: helpinfo@collect.org