Envelope from Access data

[David Sherman]

I need to create single envelopes from an Access table.

Is there any way to do this?

thanks

 

[Cybercow]

Yes, there is a way to do that. First create and format a report that will
properly reflect the size and layout of your envelope. You can then use the
following code (from http://www.mvps.org/access/reports/rpt0002.htm) to send
the one record (from a form) to that report.

Dim strDocName As String
Dim strWhere As String
strDocName = "rptSomeReport"
strWhere = "[RunID]=" & me!RunID
DoCmd.OpenReport strDocName, acPreview, , strWhere

hope this helps