Format a merge field with 22 digits

mason1100 · #1 03-27-2023, 06:09 AM

Hello,

I am having trouble with formatting a merge field with 22 digits. It is a tracking number and it should show as such:

0000 0000 0000 0000 0000 00

I understand that the \# "0000 0000 0000 0000 0000 00" will not work due to the merge field containing over 15 digits... Is there someone who could assist with a field construction for this merge field format?

Thanks in advance!

gmayor · #2 03-27-2023, 08:54 PM

Convert the formatted data to text (easily achieved in Excel) and there will be no need for a switch.

mason1100 · #3 03-28-2023, 05:12 AM

How would I achieve this in Word? That is where we are running the mail merge.

gmayor · #4 03-28-2023, 10:16 PM

You cannot do this in Word. You need to fix it in the data source. The most common data source for merge is Excel, hence my suggestion.

mason1100 · #5 03-29-2023, 05:11 AM

Thanks for the information!

gmayor · #6 04-01-2023, 09:20 PM

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

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