Word link - partway there I think (1 Viewer)

[Mahall906]

Afternoon all,

I have word document letter template called 'Warning'.

There are fields within the letter that are linked (mail merge way) to my database, including ID, name, etc.

This creates each letter perfectly for each ID.

However;

Can I change my command button, that opens the letter, to open the specific ID?

The current command is:
Private Sub command2593_Click()
Application.FollowHyperlink "S:\Enfor\Badge\Warnings\2.0 Warnings\Warning.docx"
End Sub

This opens the letter perfectly, but can I get it to choose the relevant and matching ID within the Word document

?

N.B. I have some example databases but due to company security, I cannot open them.

Thanks in advance

M

 

[Gasman]

Use a query that references the ID from your form and use that in your mailmerge?

 

[Mahall906]

Use a query that references the ID from your form and use that in your mailmerge?

Thanks Gasman.
I have a query within the database which the Word letter is getting its information from. I just cannot figure out the coding i need to use (f any) to have it selct the relevant ID letter when it opens Word.

 

[Gasman]

Well you can select recipients from within Word, but that is manual.
That is why I suggested another query that produces only that one record.

I would likely have an option button that would tell Access whether I wanted one or all records.
That would then open the relevant word document that refers to each query.

 

[Mahall906]

Well you can select recipients from within Word, but that is manual.
That is why I suggested another query that produces only that one record.

I would likely have an option button that would tell Access whether I wanted one or all records.
That would then open the relevant word document that refers to each query.

I see what you mean, I can the query down further. I like it! Thanks

 

[moke123]

Why not automate the merge from within Access?

here's an old demo