Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Is there a simpler way to get the first 2 characters of a field to appear in a mail merge? Is there a simpler way to get the first 2 characters of a field to appear in a mail merge?
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-23-2017, 03:56 PM
macropod's Avatar
macropod macropod is offline Is there a simpler way to get the first 2 characters of a field to appear in a mail merge? Windows 7 64bit Is there a simpler way to get the first 2 characters of a field to appear in a mail merge? Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,514
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
 

Tags
merged fields, nested merge

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Is there a simpler way to get the first 2 characters of a field to appear in a mail merge? How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Is there a simpler way to get the first 2 characters of a field to appear in a mail merge? mail merge (more than 255 characters) allenglishboy Mail Merge 9 03-05-2013 06:52 AM
Is there a simpler way to get the first 2 characters of a field to appear in a mail merge? Access to Word Mail Merge Issue (255 characters) ChrisPine Mail Merge 1 02-16-2012 10:01 PM
Is there a simpler way to get the first 2 characters of a field to appear in a mail merge? Characters changing between software and mail merge output?? Calastein Mail Merge 3 05-04-2011 01:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:28 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft