Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Printing Envelope

    Years ago, with the help of this forum, I created a database, for recording mechanical test releases. I used a report to print DL sized envelope, which in turn used a query to print just the records I required. I apologize now if this isn't a database problem, but I can't think what else to do. I have been given some different envelopes to use up, which are old wages envelopes. These are only 10.2cm wide by 10.9cm tall. I've tried adapting the report, but can't find a way of getting it small enough so it doesn't print extra blank envelopes. I thought of using mail merge in a word document, but can't get that to run with a query. It just prints all the records in the database. Any help, greatly appreciated.

  2. #2
    Lounger
    Join Date
    Feb 2011
    Posts
    43
    Thanks
    0
    Thanked 6 Times in 6 Posts
    Why don't you use the same query for the Word mail merge as is used to print from Access? If there was a filter being applied to the Access report, set up the same criteria in your Word Mail Merge filter. Alternatively, change the query in Access to give you just the records you want.

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    Decatur, AL
    Posts
    53
    Thanks
    2
    Thanked 0 Times in 0 Posts
    You may have already used up that envelope supply, but I asked a similar question here today and a wonderful person named orangehat gave me this perfect answer:

    I found this at another site. I tried and it only printed 1 page of 2 page report on my test.
    Private Sub cmdPrint_Click()
    DoCmd.OpenReport "Name of Report", acViewPreview
    DoCmd.PrintOut acPages, 1, 1
    DoCmd.Close acReport, "Name of Report"
    End Sub

    HTH
    Kathi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •