skkeswani,
Are you printing directly to the envelopes or printing address labels to be placed on the envelopes?
In either case, you need to create a report that matches the size of the item you're printing to. If you'll print directly on the envelope, for example, you need to make sure your report size matches the envelope size and that its set to a landscape orientation.
Use File | Page Setup from a report's design window to do this.
Next, you'll need to set up the report so it prints an appropriate number of records for each "page" (envelope or sheet of labels). If you're printing to labels, you should place a multi-record object (MRO) on your report and then set the Rows and Columns to match the number of labels on each sheet.
If you are printing labels, you'll notice the Record Layout tab on the MRO's property sheet contains two settings called "Separation." This controls the spacing between each label. For best results, set this to 0.0 for both settings. This lets you fine-tune the width and height of each label directly and I've personally found this easier to refine when there's no additional space in each label.
When yo change the separation to 0.0, you'll notice a bit of extra space along the top and left sides of the MRO. Select the outer handle and drag it down and to the right to remove this extra white space.
Next, select the MRO's Record object, right-click it, choose Properties and then select the Run Time tab. Remove the check marks in Fit Width and Fit height. This ensures each label prints in the the same amount of space. Once you've done this, adjust the size of the record size to match the size of each label on your label sheet.
If you're printing directly to envelopes, you'll want to size the Record band to match the full size of your envelope.
Now that you've sized things appropriately, drop field objects and bind them to your data tables. Test your object placements by printing a few pages and see how well they match your output. You'll probably need to experiment to get this right.
At this point, the process generally turns into one of tweaking and refinement.
To print selected addresses, use a query to grab the addresses to be printed and then use the querys Answer table as the report's master table. (See
and
for ObjectPAL based examples.)
In any event, the "trick" here is to design a report that fits results in the appropriate amount of space.
Hope this helps...
-- Lance