Create an envelope template in a report

[rookiedev]

Is it possible to set up a report that will print a number 10 envelope? I have a report that prints out and I always need to mail it. Right now I have to go through all kinds of changes to connect to Word. I would like to keep it all contained in Access with the same underlying query as the report.

Does anyone have a clue????

Thanks,
RookieDev

 

[lhite]

It's pretty straightforward. You'll want a separate report from the envelope, but use the same data source.

Start a new report (without the wizard). In design view go to FILE, PAGE SETUP. You'll probably want to set your margins smaler than the default settings. Click on the PAGE tab, set the Orientation to landscape and set the Paper Size to ENVELOPE #10 (or whatever the envelope definition is called for your printer). Click OK and set the dimensions of your report. Remove the Page Header and Footer, and I use about 8.5" by 3", which of course will depend on the margins you set earlier.

To make it look a bit better, rather than bringing in the FName field, LName field, and hoping that it is large enough, I prefer to add an unbound text box with the following expressions:
=[FName] & " " & [LName]
=[Street] (could include a second address line if your database has one)
=[City] & ", " & [State] & " " & [ZIP]

-Larry

 

[rookiedev]

Thanks Larry,
I'll give it a go and see how I fare.

RookieDev