Envelope Printing

  • Thread starter Thread starter K
  • Start date Start date
K

K

What is the most efficient way to print only a selected
envelope from a file? I need to print envelopes throut the
day and need to do this in as little time as possible.
Thanks for any info./
 
Create a Form that allows the user to select/enter the information needed to
select the particular information, then use that to create the
WhereCondition argument for a DoCmd.OpenReport for your Envelope Report.

Larry Linson
Microsoft Access MVP
 
Word is really better suited for this function.

Try publish to word, then select the address text and choose envelopes. It
may be the pain free solution you need.

Greg
 
You can make a nice report that looks just like a envelope. I done this many
times.

You just put the report in landscape, and then place the address fields. You
will have to play around to get right. Note that every printer is different
(center feed, side feed etc).

You then behind a button on the form put:

me.refresh
docmd.OpenReport "the envelope report",,,"id = " & me.id

The above code will only print ONE record.

Also, you can use word. I have a really super word merge example that you
can use in place of a report. Since word has a bet better ability for
envelops, then you can use the following example of mine and use word. The
following example is designed to only send the CURRENT RECORD to word. So,
not only is the following example good for envelopes (many of my clients use
it for this), it is also good for building single form letters.

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
 
Back
Top