Recent content by aslure

So this problem is killing me and I need some VBA help desperately. I am working in a Access 2016 environment and thought this would be easy by now. So I have a report that has all the fields (Including the ID field) from a query and a subreport on the report that connects to one of the fields...

Ohh so I understand what you mean, that is actually a smarter option. I just don't know how great I am in recreating this word doc in an access report. Is there any any information on how someone might do that?

I am bit confused by your question. I am mail merging it into word and then converting it into PDF since that is the way it needs to be sent to the client.

Yes I am trying to figure out a loop where I could save each document created by the mailmerge as a separate document with a unique name based on a field from the query.

This is what I have so far: Private Sub btnexport_Click() Dim oWord As Object Dim oWdoc As Object Dim wdInputName As String Dim wdOutputName As String Dim outFileName As String ' Set Template Path wdInputName = CurrentProject.Path & "\PDF Forms\Liability Certificates.docx" ' Create unique...

Thanks for this, however I am still having a bit of trouble getting the pieces that I want. He shows a form setup and what to do with multiple record conversion. However he does not talk about file save as unique names according to fields in the query nor how to save it as a PDF once done.

I am in a pickle, I have a query (called mailmerge) that has all the fields that match the fields in the word document that I want to mail merge into. The problem here is I need a button programmed in VBA to mailmerge the records from the query into the document. I also need each record merged...