Format a merge field with 22 digits

		Microsoft Office Forums > Microsoft Word > Mail Merge
Format a merge field with 22 digits

FAQ

Thread Tools

Display Modes

04-01-2023, 09:20 PM

gmayor

Windows 10 Format a merge field with 22 digits

Office 2019

Expert

Join Date: Aug 2014

Posts: 4,138

I have had a thought about this. If you use Merge and Split or E-Mail Merge Add-in to create the merge, you could run a macro from the process to address the formatting e.g.

Code:

Sub FixID(oDoc As Document)
Dim oRng As Range
Const strFormat As String = "0000 0000 0000 0000 0000 00"
    Set oRng = oDoc.Range
    With oRng.Find
        Do While .Execute(findText:="<[0-9]{22}>", MatchWildcards:=True)
            oRng.Text = Format(oRng.Text, strFormat)
        Loop
    End With
End Sub

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail merge field mistakenly interpret text format as date format	alan6690	Mail Merge	0	09-02-2020 01:54 AM
Merge field return last 4 digits of a number	macquhele	Mail Merge	6	08-01-2020 11:04 PM
how to format a picture switch in a merge field to only include the numbers in the middle?	becca	Mail Merge	2	06-08-2016 01:15 PM
Custom format a merge field	paul h	Mail Merge	2	09-09-2015 07:18 AM
Mail merge will not format date field generated by Excel IF statement	borntorun75	Mail Merge	3	12-16-2011 06:28 AM