Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-08-2019, 02:15 AM
ajh19742000 ajh19742000 is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2015
Posts: 7
ajh19742000 is on a distinguished road
Default Code for displaying UK postcodes correctly

Hello,
I am performing mail merges with letters and labels however our enquirers dont always use the correct way of submitting their postcodes for example PL47BJ or CH345TY. Is there a code within the mail merge field I can use to ensure the correct spacing is used to display these postcodes correctly? For example PL4 7BJ or CH34 5TY?


Thanks
Reply With Quote
  #2  
Old 01-08-2019, 01:29 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,098
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

No, there is no field coding for that - if the data have been poorly formatted on input into your data source, that's how the mailmerge will output them.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Heading not displaying correctly lucasar Word 1 06-03-2016 03:45 PM
Emails not displaying correctly in Outlook 2002 bacoms Outlook 0 02-26-2015 07:51 AM
Table of contents not displaying correctly while print preview sumayya.shaikh Word 5 01-05-2015 02:52 AM
Identifying Postcodes. Chayes Word VBA 13 09-21-2013 06:29 AM
Why is the TOC displaying as a code? ponomariov Word 1 09-28-2012 03:13 PM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft