Open mail merge ready to go from Access form

misscrf

Registered User.
Local time
Today, 13:13
Joined
Nov 1, 2004
Messages
158
have the application and I am just working on some improvements for the front end. I have about 30 mail merge letters (and 2 merge envelopes) set up for use with the records in this database.

I am working on setting up a menu with a button for each of the letters ( 2 menus, each with about 15 buttons - 1 for each letter)

Here are the things that I am looking at:

1) I tried some code, but it is only opening Word, not the file.
Here is the code:
Code:
Private Sub cmdFirstLnIntLtr_Click()
On Error GoTo Err_cmdFirstLnIntLtr_Click
  Dim wd As New Word.Application
  Dim doc As Word.Document
  
  Set doc = wd.Documents.Open("G:\HR Candidate Hiring\Staff Merge Ltrs/First Line Intvw Ltr.doc" = strDoc, AddToRecentFiles:=False)

Exit_cmdFirstLnIntLtr_Click:
  wd.Visible = True
  Exit Sub
Err_cmdFirstLnIntLtr_Click:
    Resume Exit_cmdFirstLnIntLtr_Click
    
End Sub

2) I tried a hyperlink on a button ( or doesn't really need a button) but that brings up the web toolbar floating in the Word document, and I don't want it to do that.

3) When any of the merge letters are opened, I am presented with a message:
"Opening this document will run the following SQL command:
Select * From 'qrymailmerges'
data from your database will be placed in the document. Do you want to continue?

I would like this to be answered as yes, without asking the user.

4) most people I know (including me) do not start Word with the task pane up, but for these merges, I would want the task pane to show on open, and set to the mail merge task pane, as the document is saved at the right point of the merge. This allows the user to edit the recipient list, and complete the merge.

If anyone has any suggestions, I would appreciate any help that I can get. Thanks! :D
 

Users who are viewing this thread

Back
Top Bottom