How to create an "Open & Merge" button for Word

  • Thread starter Thread starter rocketD
  • Start date Start date
R

rocketD

Hello,

I am working with a database which has a form based on a table, and a
series of Word documents that use fields from the table. Right now,
we have to get the record number from the form and then manually open
each document, using the individual record number to get the correct
data for that record into the document. I'd like to know if there is
a way to make a button that will open the document and simultaneously
merge the current record. I know there are a number of posts here
related to merging, but I'm not sophisticated enough to figure out how
to apply them to my situation. Any suggestions? Specifics would be
appreciated. :)

Thanks,
Dara
 
I know it may require some work on your part but you really should take a
look at

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

specifically the 'Super Easy Word Merge'. Simple and effective. His
technique works very well!
--
Hope this helps,

Daniel P







- Show quoted text -
Click to expand...

Thanks - I have looked at the code before, but I can't figure out how
to make it work with my database and my merge document. I'll settle
for just opening the merge form - I tried the
Application.FollowHyperlink function in VB, but I can't get that to
work either. This is the exact code I used for that:

Private Sub wdExpChr0607_Click()
Application.FollowHyperlink ("G:\03 - REVIEWER TOOLS\STAFF REVIEW
SHEETS-May06\06-07 Merge Fields\Staff Review - New Expedited MERGE
06-07")
End Sub

Any idea why this won't work? Is it because of all of the spaces in
the file path? (I can't do anything about that, so they'll just have
to stick with manual manipulation if that's the case)

Thanks,
Dara
 
Try

Private Sub wdExpChr0607_Click()
Dim strDoc as String

StrDoc = "G:\03 - REVIEWER TOOLS\STAFF REVIEW
SHEETS-May06\06-07 Merge Fields\Staff Review - New Expedited MERGE
06-07"
Application.FollowHyperlink strDoc
End Sub
 
Back
Top