#1
|
|||
|
|||
Format a merge field with 22 digits
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! |
#2
|
||||
|
||||
Convert the formatted data to text (easily achieved in Excel) and there will be no need for a switch.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
How would I achieve this in Word? That is where we are running the mail merge.
|
#4
|
||||
|
||||
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.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#5
|
|||
|
|||
Thanks for the information!
|
#6
|
||||
|
||||
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 |
Tags |
mailmerge, mergefield, switches |
|
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 |