Thread: [Solved] Is there a simpler way to get the first 2 characters of a field to appear in a mail merge?
View Single Post
 
Old 03-23-2017, 03:56 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
You could do it with 52 IF tests for all records:
{IF{MERGEFIELD Staff_ID = "A*" "A"}{IF{MERGEFIELD Staff_ID}= "B*" "B"}{IF{MERGEFIELD Staff_ID = "C*" "C"} ... {IF{MERGEFIELD Staff_ID}= "Z*" "Z"}
for the first letter, and
{IF{MERGEFIELD Staff_ID = "?A*" "A"}{IF{MERGEFIELD Staff_ID}= "?B*" "B"}{IF{MERGEFIELD Staff_ID = "?C*" "C"} ... {IF{MERGEFIELD Staff_ID}= "?Z*" "Z"}
for the second letter.

I'm with Graham on this one though - simpler to modify the data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote