#1
|
|||
|
|||
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?
|
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Cheers back at you.
Thanks |
|
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 |
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 |
Mail merge will not format date field generated by Excel IF statement | borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |