Mail merge for current record only...

  • Thread starter Joshua K Briley
  • Start date
J

Joshua K Briley

Hello,

I have a macro set up to merge information from a query to a word document.
Currently this macro sends information on ALL records contained in the query,
but I'd like to have it set up where it only selects the current record on a
particular form.

The cuurent code is:

Private Sub Command22_Click()
On Error GoTo Err_Command22_Click

Dim stDocName As String

stDocName = "new envelope macro"
DoCmd.RunMacro stDocName

Exit_Command22_Click:
Exit Sub

Err_Command22_Click:
MsgBox Err.Description
Resume Exit_Command22_Click

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Message Box to Display a count of Records 3
Exit Code 2
Vb code working one time 1
Error "Object variable or With block variable not set" 3
Go to New Record 0
Access Macro links to Word Template - NEED TO UPDATE DATA - HELP 0
drop down list: how to open on cursor 3
How do I delete a record based on a user enetered string value 1

Top