We use the Word's Mail Merge function to produce, well, a mail merged document. Then, using the attached Code, the user can run a macro that will separate out each record and save them individually.
The macro looks for a section break and "cuts" everything prior to it and save it in a new file. This have been working great until now. our forms are getting more complicated and the section break isn't cutting it.
How can i modify the macro to look for another "trigger" other than a section break? I'm open to using any ascii character, a text in white font (which won't print), or any other suggestion
' splitter Macro
Dim mask As String
Letters = Selection.Information(wdActiveEndSectionNumber)
'mask = "ddMMyy"
Counter = 1
While Counter < Letters
DocName = "U:\" & Environ("USERNAME") & "\SepDocs\" & Format(Time, "h mm ss") & " " & LTrim$(Str$(Counter))
Documents.Add Template:="V:\Macros\Template.doc", _
ActiveDocument.SaveAs FileName:=DocName, FileFormat:=wdFormatDocument
Counter = Counter + 1