Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2015, 11:34 AM
paul h paul h is offline Custom format a merge field Windows 7 32bit Custom format a merge field Office 2007
Novice
Custom format a merge field
 
Join Date: Jul 2015
Location: Richmond
Posts: 23
paul h is on a distinguished road
Default Custom format a merge field

I am exporting a merge file from Access that has Soc Sec Num as a merge field. Can I simply export the unnformatted number and then format it in the merge field as using a Social Sercurity format i.e. 111-22-3333 like I would use in Access or Excel?
Reply With Quote
  #2  
Old 09-08-2015, 03:40 PM
macropod's Avatar
macropod macropod is offline Custom format a merge field Windows 7 64bit Custom format a merge field Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

What Access and Excel have is a display format for SSNs. You can achieve the same in a mergefield via a switch. Right-click on your mergefield and press Shift-F9. You should see something like:
{MERGEFIELD SSN}
Add a numeric picture switch, thus:
{MERGEFIELD SSN \# "000'-'00'-'0000"}
Press F9 to update the field, then run your merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-09-2015, 07:18 AM
paul h paul h is offline Custom format a merge field Windows 7 32bit Custom format a merge field Office 2007
Novice
Custom format a merge field
 
Join Date: Jul 2015
Location: Richmond
Posts: 23
paul h is on a distinguished road
Default

Cheers back at you.

Thanks
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom table of contents referencing a custom field skaboy607 Word 3 01-16-2014 06:59 AM
Email Merge with custom From: field. Budlong Mail Merge 0 09-17-2013 06:15 PM
Custom format a merge field How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Merge field source data field kckay Mail Merge 4 03-25-2013 11:06 AM
Custom format a merge field Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:52 AM.


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