Macro to open Word document with bookmarks issue

[christosf360]

Hello everyone, very new to Access.



I am trying to create a button that will run a macro and this macro needs to open up a Word file and use bookmarks to copy and paste some of the data from the Access database (people's names, addresses etc) into the Word document. I am using the code below to open the Word document but it fails. The computer is trying to open it but eventually nothing happens and no errors occur either.

I did go into VBA and into References and I linked with the Word Object Library. I also need to say that in our organisation we are using Microsoft Teams for file storage so in the code below, the path is a link pasted from Teams. I believe that the path is accurate because the code doesn't produce any errors, the computer tries to open the file for a second or two and than it stops and nothing happens. Any advice please?...?

Dim wApp As Word.Application
Dim wDoc As Word.Document

Set wApp = New Word.Application
Set wDoc = wApp.Documents.Open("path/FileName.docx")

[moke123]

try Albert's Super easy word merge. http://www.kallal.ca/msaccess/msaccess.html

[madpiet]

you only need VBA if you're doing something outside the bounds of what a regular mail merge will do... in other words, merge a single record at a time from a table or query in your database to a single document. So you get one document per record in your dataset. If you need something like all the child records of some parent record to be included too (like an invoice), then you need to use bookmarks or similar, because then you need to merge in the parent records and then insert and expand the child data to a table in your Word document. But this sounds like the simple version.

[CJ_London]

I believe that the path is accurate because the code doesn't produce any errors

Set wDoc = wApp.Documents.Open("path/FileName.docx")

Is that really your code? If so you don't have a drive, the folder is called 'path' and the name of the file is 'filename'

[christosf360]

Is that really your code? If so you don't have a drive, the folder is called 'path' and the name of the file is 'filename'

No, this isn't the path, the real path has a drive and a proper file name.

[Welshgasman]

Hello everyone, very new to Access.

I am trying to create a button that will run a macro and this macro needs to open up a Word file and use bookmarks to copy and paste some of the data from the Access database (people's names, addresses etc) into the Word document. I am using the code below to open the Word document but it fails. The computer is trying to open it but eventually nothing happens and no errors occur either.

I did go into VBA and into References and I linked with the Word Object Library. I also need to say that in our organisation we are using Microsoft Teams for file storage so in the code below, the path is a link pasted from Teams. I believe that the path is accurate because the code doesn't produce any errors, the computer tries to open the file for a second or two and than it stops and nothing happens. Any advice please?...?

Dim wApp As Word.Application
Dim wDoc As Word.Document

Set wApp = New Word.Application
Set wDoc = wApp.Documents.Open("path/FileName.docx")

That appears to open with a default path?

What are you expecting to happen?, that the word document will come to the foreground?

[christosf360]

That appears to open with a default path?

What are you expecting to happen?, that the word document will come to the foreground?

I was expecting the word document to open, isn't that what the Open.file command would do?

When the Word document is open, I would like to use bookmarks to copy and paste data from Access into the Word template. Am I doing it wrong?...?

Thanks

[Welshgasman]

It will open hidden unless you set the Visible property to true.

Have you tried Google?, that is always my first point of call.

https://www.google.com/search?q=acce...hrome&ie=UTF-8