Albert Kallal's Word Merge

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

Thank you first of all, Mr. Kallal, for sharing this. I
found this code through a Microsoft newsgroup and it seems
to be the answer to my merge dilemmas, however the "merge
single record" works very well but the "merge all records"
produces the following error: Run Time Error 91 - Object
variable or with block variable not set and it brings me
to the module Word Code here and it points to the line
clsRidesPBar.HideProgress:

exit1:

clsRidesPBar.HideProgress
MsgBox "No data was created for this merge" & vbCrLf & _
"Make sure the sql is correct" & vbCrLf & _
"sql was " & vbCrLf & vbCrLf & strSql, _
vbCritical, "no data for this merge"

MergeAllWord = False

I have no idea how to get this working.
 
If the highlighted line is clsRidesPBar.HideProgress
then the error message is indicating that there is not a current object call
clsRidesPBar

So find out what sort of object it is, it may have neen destroyed too early.
 
Back
Top