Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-07-2016, 07:18 AM
becca becca is offline how to format a picture switch in a merge field to only include the numbers in the middle? Windows 10 how to format a picture switch in a merge field to only include the numbers in the middle? Office 2013
Novice
how to format a picture switch in a merge field to only include the numbers in the middle?
 
Join Date: Jun 2016
Posts: 2
becca is on a distinguished road
Default how to format a picture switch in a merge field to only include the numbers in the middle?


I am trying to use a merge field in which the merged field only includes numbers and I want to use a picture switch or some other mechanism so that only numbers in the middle of the field appear. I can figure out how to make only the last group of numbers appear in the merged document, but not numbers in the middle. For example, the merged field will always consist of 6-digit number (e.g., 123456) and I want only the 2nd and 3rd numbers (from the right) to print (in this example, the 4 & 5 to print as 45). Is it possible to manipulate the merge field code to do this? I appreciate any help!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to format a picture switch in a merge field to only include the numbers in the middle? Define custom Cross-reference output format to include "static" text and pg numbers cyclops755 Word VBA 9 01-17-2023 02:42 PM
how to format a picture switch in a merge field to only include the numbers in the middle? Custom format a merge field paul h Mail Merge 2 09-09-2015 07:18 AM
Macro to select an { includepicture } field code and format the picture behind text and 100% scale sanpedro Word VBA 3 03-30-2015 10:50 PM
how to format a picture switch in a merge field to only include the numbers in the middle? Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
how to format a picture switch in a merge field to only include the numbers in the middle? Adding a DASH in the middle of my field steven.allman Mail Merge 5 04-11-2011 02:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:15 AM.


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