Results 1 to 10 of 10
  1. #1
    Pantinosm is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    16

    Export my 2 page report to the top of a word template

    Hi All,



    excuse my question if it sounds esy or simple. I have a report with a lot of data that i want to merge with a static ms word template of 12 pages. What is the best way to do this?

    thank you in advance.

    Pantinos

  2. #2
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    Could you tell us some more detail? Do you want word to be one document or many documents? what do you mean by merge?


    If you mean mail merge this is very useful and splits up documents as you make them.

    http://www.gmayor.com/individual_merge_letters.htm

  3. #3
    Pantinosm is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    16
    I mean i have a report in access that is populated from a complex query. I want a way to export this report inside the top of a readymade Word document that has 10 static pages. I don't mean mail merge.

  4. #4
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    You could create the PDF report as you want it then embed it into the word document. Or even create an interactive PDF if that's something you're interested in.

    If neither of those are any good,

    you could export to excel then have that as a table in the word doc. (I don't know if its possible to have a direct link from word to access)

  5. #5
    Pantinosm is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    16
    can this be done with vba? I mean create first the pdf and embed in word? This is something a user will do so it must be easy for him.

  6. #6
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    Yes, do you want the report to be visible on full screen (embedded) or open when selected?

  7. #7
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    This here should help you:

    http://www.onlinepclearning.com/embed-pdf-in-word/

    I'm sure if you clicked record macro and then do this you could assign that macro somewhere or edit it.

  8. #8
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    Code:
    Selection.InlineShapes.AddOLEObject ClassType:="AcroExch.Document.DC", _
            FileName:="", LinkToFile:=False, DisplayAsIcon:=False
    This will open a file explorer window and then once the file is selected it will paste it into word. ( I had to run this through the developer tab and then macro.)

  9. #9
    Pantinosm is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    16
    Embedded if possible in word.

  10. #10
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    check out that macro, see what you think.

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

Similar Threads

  1. export access report to word
    By afshin in forum Access
    Replies: 6
    Last Post: 01-15-2014, 12:11 AM
  2. Export report directly to Word format (.doc)
    By rumenrs in forum Import/Export Data
    Replies: 2
    Last Post: 06-12-2013, 12:34 AM
  3. Export report to Word
    By Lowell in forum Reports
    Replies: 1
    Last Post: 02-06-2013, 11:54 PM
  4. Export report to word document
    By jackyoung2012 in forum Reports
    Replies: 1
    Last Post: 03-16-2012, 11:16 AM
  5. Replies: 7
    Last Post: 08-31-2010, 12:15 PM

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