G'day experts
I currently enjoy the VBA code that splits mail merged documents into seperate documents in a loop (the code copies all text to 1st section break, pastes into new doc and saves). This works great BUT becaues of the standard layout of the resultant letters I think it should be possible to open the Save dialogue box at the correct path thus avoiding the user from having to browse and locate the folder each time they save one of the documents.
I can use the code to store what should be the path into the variable NetworkDrivePath
Bascially experts I'd love some code that can
Check that NetworkDrivePath exists, if not open the save dialgue at the default location otherwise open the SaveAs dialgue at the path of NetworkDrivePath. At this time I don't want to take the code further and auto save as the staff want to maintain control/faith that correct saving is occuring.
Thanks in advance for any help.
Start Free Trial
