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
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
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
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.
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)
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.
Yes, do you want the report to be visible on full screen (embedded) or open when selected?
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.
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.)Code:Selection.InlineShapes.AddOLEObject ClassType:="AcroExch.Document.DC", _ FileName:="", LinkToFile:=False, DisplayAsIcon:=False
Embedded if possible in word.
check out that macro, see what you think.