Quote:
Originally Posted by Jenn68
It appears I have discovered the problem.
|
Would you care to share the solution.?
I've not done a mailmerge with VBA (yet), but I would have thought you possibly needed a Close statement?
Code:
With oDoc2
myPath = "H:\PWS\Parks\Parks Operations\Sports\Sports15\WORKORDERS\" & Format(ws_vh.Range("B2"), "ddd dd-mmm-yy")
.SaveAs myPath & "\" & rpt_od & ".docx"
.Close
End With