Results 1 to 4 of 4
  1. #1
    gaby58 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    19

    Question Printing Address and Content in a word Document


    Hi All,

    I have a table which has Students names and DOB and the School District with address they belong to, some school district have multiple users, Also there is a common content for all these School districts. We want to send a letter to the School , the information need to be like this and it needs to be saved in pdf document, could you please suggest if there is a way to do this.

    Our School Logo


    School Name
    Address

    Attention: School Name Coordinator

    Content of the mail (it remains same for all schools)

    Student Last Name| Student First Name| DOB

    Thank you so much for any suggestions and tips

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if the data is in Access, why not just build a report and produce the PDF, group by item; School, LastName,
    then produce pdf:

    vRpt = "rMyReport"
    vFile = "c:\folder" & vRpt & ".pdf"
    docmd.OutputTo acOutputReport ,vRpt, acFormatPDF,vFile

    you can use a form with a list box to loop thru all items to produce many pdfs by name for example:
    vFile = "c:\folder" & lstBox & ".pdf"

  3. #3
    gaby58 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    19
    Thank you, will try and let you know

  4. #4
    gaby58 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    19

    Reporting question

    Quote Originally Posted by ranman256 View Post
    if the data is in Access, why not just build a report and produce the PDF, group by item; School, LastName,
    then produce pdf:

    vRpt = "rMyReport"
    vFile = "c:\folder" & vRpt & ".pdf"
    docmd.OutputTo acOutputReport ,vRpt, acFormatPDF,vFile

    you can use a form with a list box to loop thru all items to produce many pdfs by name for example:
    vFile = "c:\folder" & lstBox & ".pdf"
    Actually the report should contain header where it will have Address of the school and Address, City, State and zip are in different columns, so how do I group this in order to get multiple students under one school when they belong to that school

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-27-2017, 12:06 PM
  2. Replies: 8
    Last Post: 09-03-2015, 08:16 PM
  3. Create new Word document.
    By Bill H in forum Programming
    Replies: 3
    Last Post: 06-12-2012, 06:40 AM
  4. Import Word document using VBA
    By degras in forum Import/Export Data
    Replies: 4
    Last Post: 04-12-2011, 02:40 AM
  5. Open a word document from access
    By natalia in forum Programming
    Replies: 1
    Last Post: 10-13-2010, 08:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums