Envelope from Access data

  • Thread starter Thread starter David Sherman
  • Start date Start date
D

David Sherman

I need to create single envelopes from an Access table.

Is there any way to do this?

thanks
 
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
 
Back
Top