View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Decembersonata Decembersonata is offline
external usenet poster
 
Posts: 3
Default Access to Word Mail Merge

I have an Access db that currently is the data source for a mail merged Word
doc. The user presses a button on the Access form to take them directly to
the mail merged document, here is the code:

Private Sub Command125_Click()
Set appWd = CreateObject("Word.Application")
appWd.Visible = True
appWd.Documents.Open
FileName:="I:\groups\PAYROLL\Payroll_Renwals\RENEW-LETTER-sef.docx"
End Sub

The Word doc opens just fine, however it does not automatically link to the
saved data source (in this case a table from the database), so the user has
to manually select the data source in order to update the information. Is
there a way to link out to this Word doc from Access, opening the document
with the data source in tact?