Printing one envelope?

[klack]

How do you print one envelope from a database of names and
addresses in Access? I can print labels, I can create sub
groups of data, but cannot figure out how to print one
envelope from the list.

 

[Richard]

Do you have a form that can display the one address you need on the
envelope?

Richard

 

[Guest]

I am attempting to do same thing. I am able to PrintPreview, but when I click
Print it print all 168 records.
I need to know how to print one envelope for the record I am viewing.
Thanks.
Joan

 

[Alfred]

Do something like this
You must replace employeeNo with your unique identifying number or sting

Dim stLinkCriteria As String
stLinkCriteria = "[EmployeeNo]=" & Str(Nz(Me![EmployeeNo], 0))
Dim stDocName As String

stDocName = "EmpPayRpt" ' your report name
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
Alfred

 

[Guest]

Yes. The following is the code that allows everything to happen except for me
the option to select the printing of an envelope for the record I am viewing.

stDocName = "Envelope"
DoCmd.OpenReport stDocName, acViewPreview
Any help appreiciated. Joan

Do something like this
You must replace employeeNo with your unique identifying number or sting

Dim stLinkCriteria As String
stLinkCriteria = "[EmployeeNo]=" & Str(Nz(Me![EmployeeNo], 0))
Dim stDocName As String

stDocName = "EmpPayRpt" ' your report name
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
Alfred

I am attempting to do same thing. I am able to PrintPreview, but when I
click
Print it print all 168 records.
I need to know how to print one envelope for the record I am viewing.
Thanks.
Joan