Merge field return last 4 digits of a number

macropod · #7 08-01-2020, 11:04 PM

Running my macro as part of the mailmerge would require no more than:

Code:

Sub MailMergeToDoc()
Application.ScreenUpdating = False
ActiveDocument.Mailmerge.Execute
ActiveDocument.Range.Find.Execute FindText:="[0-9]{12}([0-9]{4})", ReplaceWith:="\1", MatchWildcards:=True, Replace:=wdReplaceAll
Application.ScreenUpdating = True
End Sub

Execution would then be via Mailings>Finish & Merge>Edit Individual Documents, the same as with any regular merge. Regardless, a macro really isn't needed...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unable to insert line break or carriage return in mail merge field	shahid.majeed	Mail Merge	4	09-19-2019 01:08 AM
Entering a number of 19 digits	Jo Freeman	Excel	11	11-08-2017 06:20 AM
Having number's digits together	mohsen.amiri	Word	0	06-23-2017 01:20 AM
How do I create a field that will return the current paragraph number minus one in an automatic list	gugootz	Word	1	11-23-2015 04:58 PM
Use a numerical merge field to subtract that number of months	MichaelSpedding	Mail Merge	8	11-11-2015 01:11 PM